Add months to date

[agibsonsw]

Hello. Excel 2007.

Has someone got a reliable formula that will add a number of months (precisely) to a date? (Without VBA?)
I don't just want to add 90 days for 3 months..
Thanks, Andy.

[HansV]

The EDATE function is built into Excel 2007 (in earlier versions, it was part of the Analysis ToolPak add-in).
Its syntax is =EDATE(date,months)
For example, with a date in A1, the formula to return the date 3 months later is

=EDATE(A1,3)

If you use a negative number for months, the result is the specified number of months before the date.

[agibsonsw]

Thank you.