Excel - Changing value of a date by a number of calendar months

[Guest]

in excel is there a formula that allows me to increase a date by an exact
number of calendar months? e.g., I want to increase the date of 28-Feb-2006
by 3 calendar months to 28-May-2006

 

[CLR]

With your date in A1......

=MONTH(A1)+3&"/"&DAY(A1)&"/"&YEAR(A1)

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

Maybe...

=date(year(a1),month(a1)+3,day(a1))

But this may cause trouble when the dates are near the end of the month (Aug 30
& 31 would go to what date?

 

[Guest]

Thanks - Just what I was looking for. The problem as you mentioned is minor
(also happens for Feb 29 and leap years!) and when it happens it returns the
next 'real' day.
regards.