Help! Automatically roll out a series of date by adjusting the duration

Hi All!

I am new to VBA and need some help to write a code to auto-generate a date series controlled by a limit.

Example:

In cell A1 I input 12 (which means next 12-months) and in A2 is today's date, I'd like to have a series of date of the next 12 months automatically generated in the cell A3 and beyond (Feb 14, 2015, march 14 2015, etc.).

I'd like it to be dynamic so when I change the value in A1 the date range also expand/shorten automatically.

Thanks a lot!!!!

Try this

Please Login or Register  to view this content.

Thanks Yasser!

I just tried and I realized I miscommunicated in my original post - the range should be in a row not a column so starting cell C1,D1,E1...Also the year begins with 1900 instead of 2015. Could you design another one?

Cheers

Please Login or Register  to view this content.

Put the integer in A1 . The start date in A2
The results will be as you mentioned in the last post

Thanks! It only goes to 11 months somehow when I input 12.

I tested it and everything is ok
Do you want the date entered in A2 to be in results??

Yes Please

Try

Please Login or Register  to view this content.