Creating a month series

[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?

 

[dvt]

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?

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

 

[JS]

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