Returns the date that is the specified number of months before or after the specified date.
Syntax
![]() |
---|
EDATE( Date startDate, Integer months ) → Date |
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.
Formula
![]() |
---|
=EDATE(TODAY(),1) |
Function Reference
DAYS Function
EOMONTH Function