Returns the date that is the specified number of months before or after the specified date.
Syntax
 Copy Code
|
|---|
EDATE( Date startDate, Integer months ) → Date |
Parameters
- startDate
- Required. The start date.
- months
- Required. The number of months before or after startDate.
Remarks
If the specified months value is not integer, it is automatically truncated. If the result is not representable as a date, the function returns the #VALUE! error value.
Example
| Formula
Copy Code
|
|---|
=EDATE(TODAY(),1) |
See Also
Function Reference
DAYS Function
EOMONTH Function