EDATE function
EDATE(Date,
Months) EDATE(Date;
Months)
Date
Number or { Number }
The original date as a sequential serial number.
Months
Number or { Number }
The number of months to set back or advance the original date. A positive number advances the original date and a negative number sets it back.
Returns
Number or { Number }
A sequential serial number representing a date advanced or set back a number of months relative to a given date.
Returns a date advanced or set back a number of months.
Examples
Returns a sequential serial number representing May 1, 1983 (May 1, 1981, advanced 24 months).
Returns a sequential serial number representing May 1, 1979 (May 1, 1981, set back 24 months).