The EDATE function returns a date/time value that is some number of months before or after a given date.
EDATE(start-date, month-offset)
start-date: The starting date. start-date is a date/time value (the time portion is ignored) or date string.
month-offset: The number of months before or after the starting date. month-offset is a number value. A negative month-offset is used to specify a number of months before the starting date and a positive month-offset is used to specify a number of months after the starting date.
Examples |
|---|
=EDATE(“1/15/2000”,1) returns Feb 15, 2000, the date one month later. =EDATE(“1/15/2000”,-24) returns Jan 15, 1998, the date 24 months earlier. |