Please note the nature of EDATE.

From Excel Help:

Use EDATE to calculate maturity dates or due dates that fall on the **same** day of the month as the date of issue.

Epinn

"Epinn" wrote in message ...
Regarding your example, I don't think the result for 30 months is 11/1/08. It should be 7/1/2009.

Another way:

In cell A1: 1/1/07

For 3 months: =EDATE(A1,3)
For 30 months: =EDATE(A1,30)

Like Bernard said format cell ......

If EDATE function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

Epinn

"Kimberly" wrote in message ...
Does anyone know how to create a formula that will calculate 3 & 30 months
from any given date?

Date 3 mon 30 mon
Example: 1/1/07----- 4/1/07----- 11/1/08