Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

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).