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