Heater,

In B15, enter the formula

=DATE(YEAR($B$9),MONTH($B$9)+ROW()-14,1)

And fill down as far as you need.

HTH,
Bernie
MS Excel MVP

"heater" wrote in message
...
I am setting up an amortization table and want to add one month to the
previous month:

Ex: b9 has the start date 12/1/04
b15 needs to be the next month Jan 05
b16 Feb 05 and so on for 10 years

The problem comes in 2007 (must be a leap year) it skips a month and
throughs the whole thing off.