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