Add one month to the previuos month
 

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.

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.

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.

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.

--
Regards
Roger Govier
"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.

On Wed, 9 Feb 2005 10:19:03 -0800, heater
wrote:

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

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

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



--
Regards,
Fred
Please reply to newsgroup, not e-mail


"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.