AlanB
10-24-2020, 01:59 PM
Hi all,
I have a large project coming up where I will have to input dates which are certain time period away from a lot of upcoming events, and I was hoping to use a VBA to quicken this task up for me.
Dates of the events would be found in multiple columns from B onwards and always in Row 2. From the date that the code finds in each column I would like it to input 1 week out, 2 weeks out, 1 month out, 2 months out and so on up to 6 months out from the original date in the rows below.
I have found the formula's that would do this using Edate but struggling to convert it to a VBA that could handle lots of dates in Row 2.
Thanks for any help.
Alan
I have a large project coming up where I will have to input dates which are certain time period away from a lot of upcoming events, and I was hoping to use a VBA to quicken this task up for me.
Dates of the events would be found in multiple columns from B onwards and always in Row 2. From the date that the code finds in each column I would like it to input 1 week out, 2 weeks out, 1 month out, 2 months out and so on up to 6 months out from the original date in the rows below.
I have found the formula's that would do this using Edate but struggling to convert it to a VBA that could handle lots of dates in Row 2.
Thanks for any help.
Alan