Need help with creating a formula
Was not aware of the EDATE function. Thanks.
--
Y
"Epinn" wrote:
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
|