EDATE


Returns a date a number of months away.

Syntax:

EDATE(startdate, months)
months is a number of months that are added to the startdate. The day of the month remains unchanged, unless it is more than the number of days in the new month (when it becomes the last day of that month). months may be negative.

Example:

EDATE("2008-10-15", 2)
returns 15 Dec 08.
EDATE("2008-05-31", -1)
returns 30 Apr 08. There are only 30 days in April.






This page is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof