EDATE (date before/after n months)

<< 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:

EOMONTH