Only with a formula, how do I increase the months?
 

I have been trying to set up an amortization scedule where it will
automatically place the dates into cells. These cells would represent the
different months for the length of the loan. This is to be accomplished by
only typoing in the starting date. Example If the loan is to start on
11/1/2005, then the first cell in the program will have 11/1/2005 in it. How
do I create a formula so the next cell below it will show 12/1/2005, the next
1/1/2006, etc for the length of the loan. If I understood how to create the
formula (no fill boxes nor drag and drop) then I know how to do the rest.
Right now when I add 1 to the previous cell it only changes the day of the
month. I need to change the month only and not the day and the year to
change after the December to January switch.
Thanks for your help,
Greg

Only with a formula, how do I increase the months?
 

suppose 11/1/2005 is in cell A1

formula in cell A2 will be =date(year(a1),month(a1)+1,1)
A3: =date(year(a2),month(a2)+1,1)

etc

"Greg" wrote in message
...
I have been trying to set up an amortization scedule where it will
automatically place the dates into cells. These cells would represent the
different months for the length of the loan. This is to be accomplished
by
only typoing in the starting date. Example If the loan is to start on
11/1/2005, then the first cell in the program will have 11/1/2005 in it.
How
do I create a formula so the next cell below it will show 12/1/2005, the
next
1/1/2006, etc for the length of the loan. If I understood how to create
the
formula (no fill boxes nor drag and drop) then I know how to do the rest.
Right now when I add 1 to the previous cell it only changes the day of the
month. I need to change the month only and not the day and the year to
change after the December to January switch.
Thanks for your help,
Greg