Description
Used to return the date after given number (n) months. For example, you are told that your 1st installment will be due in ten (10) months starting from next Monday (e.g. 25-Aug-1990).
=EDATE(start_date,months)
The EDATE function syntax has the following arguments:
- Start_date Required.
A date that represents the start date.
NOTE: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(1990,8,25) for the 25th day of August 1990. Problems can occur if dates are entered as text.
- Months Required.
The number of months before or after start_date.
A positive value for months yields a future date whereas,
A negative value yields a past date.
