Adding months.

[Guest]

I need to set up a string of dates. How can I do this so that if i change
the first month all the following months change as well? If I enter a date
in cell A1 and then type "=A1+1" in cell B1 one day is added to the date. I
want to add one month. Please help!!

 

[Bob Phillips]

=date(Year*A1),MONTH(A1)+1,day(a1))


although this doesn't work if the day is greater than the nextmonth has, eg
31st Jan.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

The Analysis Toolpack add-in adds some date functionality. If you have the
Analysis Toolpack add-in installed, you can type "=edate($a$1,1)" in cell B1.
This increments the month by 1.