Date formula

[CB]

Hi,
I would like to be able to add months to a particular
date. For example, March 5, 2004 is 4/5/04 and I would
like to add 9 months to that date so that Excel takes
care of the different lengths of months into account.

I guess the formula would look something like:

=A4+9months
where A4 contains the starting date.

Thanks for your help!

 

[Aladin Akyurek]

One of:

=EDATE(A4,9)

=DATE(YEAR(A4),MONTH(A4)+9,DAY(A4))

 

[Frank Kabel]

Hi
try as a genral formula
=DATE(YEAR(A4),MONTH(A4)+add_months,MIN(DAY(A4),DAY(DATE(YEAR(A4),MONTH
(A4)+add_months+1,0))))

for adding 9 months use
=DATE(YEAR(A4),MONTH(A4)+9,MIN(DAY(A4),DAY(DATE(YEAR(A4),MONTH(A4)+9+1,
0))))