Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The EDATE function helps you find a date that is a certain number of months away from a starting date. This can be useful for calculating due dates, deadlines, or maturity dates that are based on a specific time frame.
Syntax
EDATE(start_date, months)
The EDATE function syntax has the following arguments:
- start_date Required. The date from which you want to start counting. Dates should be entered either by using the "YYYY-MM-DD" format or by using the DATE function, or as results of other formulas or functions.
- months Required. The number of months you want to add to (or subtract from) the start date. If this number is positive, it adds months; if negative, it subtracts months.
Remarks
- The function calculates the date that is 'months' away from 'start_date'. For example, EDATE(DATE(2020, 1, 15), 1) gives you February 15, 2020, since that's one month after January 15, 2020.
- If 'months' is negative, it calculates the date that is 'months' before 'start_date'. For example, EDATE(DATE(2020, 1, 15), -2) gives you November 15, 2019, which is two months before January 2020.
- If the resulting date falls outside the valid date range, the function will return an error.
Example
| Formula | Description | Result |
|---|---|---|
| =EDATE(2022-01-01, 1) | Date one month after January 1st, 2022. | 2022-02-01 |
| =EDATE(2020-02-07, -1) | Date one month before February 7th, 2020. | 2020-01-07 |
| =EDATE(DATE(2021, 3, 15), 6) | Date six months after March 15th, 2021. | 2021-09-15 |
Errors
For a full list of formula errors, please read Formula errors.