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