Add one month to the previuos month

[Guest]

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.

 

[Dave O]

Try this formula in B15: =EOMONTH(B9,0)+1

.... and then this one in B16: =EOMONTH(B15,0)+1

You may need to format these as dates. The EOMONTH() formula
determines the last day of the month; adding one yields the next day,
or the first day of the next month.

 

[Bernie Deitrick]

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

 

[Roger Govier]

Hi

You could enter 1/1/05 in B15 then right click on the fill handle at the
bottom right of the cell and drag down for the range required.
When you release the right mouse button, choose Fill Months.

 

[Ron Rosenfeld]

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

How are you doing this?

By the way, 2007 cannot be a leap year.

--ron

 

[Fred Smith]

And one more formula, which I use because it's more intuitive to me:

=date(year(b9),month(b9)+1,day(b9))