Creating a month series

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am creating an amortization schedule that I would like
a column to automatically fill with 360 consecutive
months based on dynamically changing data. For example,
If a user enter a date of 7/8/2003, the spreadsheet would
automatically fill in the column with 8/1/2003,
9/1/2003 ... 7/1/2033 without the user having to do
anything. Is this possible?
 
John said:
I am creating an amortization schedule that I would like
a column to automatically fill with 360 consecutive
months based on dynamically changing data. For example,
If a user enter a date of 7/8/2003, the spreadsheet would
automatically fill in the column with 8/1/2003,
9/1/2003 ... 7/1/2033 without the user having to do
anything. Is this possible?
Click to expand...

If A1 contains 7/8/2003, put this in A2:
=DATE(YEAR(A1),MONTH(A1)+1,1)

Copy that formula down as far as needed.

Dave
dvt at psu dot edu
 
I think this formula should do it

=DATE(YEAR(E3),MONTH(E3)+1,DAY(E3))

where E3 is your starting date - drag the formula down until you have the
360 months forward
 
Back
Top