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

EDATE(DATE(1981, 5, 1), 24)EDATE(DATE(1981; 5; 1); 24)

Returns a sequential serial number representing May 1, 1983 (May 1, 1981, advanced 24 months).

EDATE(DATE(1981, 5, 1), -24)EDATE(DATE(1981; 5; 1); -24)

Returns a sequential serial number representing May 1, 1979 (May 1, 1981, set back 24 months).

EDATE(DATE(1981, 5, 1), { 24, -24 })EDATE(DATE(1981; 5; 1); { 24; -24 })

Returns an array of sequential serial numbers representing the dates May 1, 1983 (May 1, 1981, advanced 24 months) and May 1, 1979 (May 1, 1981, set back 24 months).