<< Click to Display Table of Contents >> EDATE (date before/after n months) |
Syntax:
EDATE(StartDate, m)
Description:
Returns the date that is m months before/after StartDate. This enables you to determine appointments that fall on the same day of another month.
m is the number of months.
If m is positive, a date in the future will be returned, with m months behind the StartDate.
If m is negative, a date in the past will be returned, with m months before the StartDate.
m should be an integer. Digits right of the decimal point are ignored.
Example:
EDATE("03/30/2018", 1) returns 04/30/2018
EDATE("03/31/2018", 1) returns 04/30/2018 as well, because April has just 30 days.
See also: