EDATE
Use the EDATE function to modify dates by a specified number of months.
Use
EDATE( start_date, months )
Returns the date adjusted by the number of months before or after the start date.
Parameter | Required | Description |
---|---|---|
start_date | Yes | a date that represents the start date |
months | Yes | the number of months before (negative) or after (positive) the start_date |
Returns | Date |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.