EDATE Function in Excel, Google Sheets, Airtable & Notion
EDATE returns the same day of the month a number of months before or after a date. When that day does not exist, it uses the last day of the month.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | EDATE(start_date, months)Returns a serial number — format the cell as a date. |
| Google Sheets | ✔ Built in | EDATE(start_date, months) |
| Airtable | ✔ Built in | DATEADD(date, months, 'months')Also clamps to the end of the month, like EDATE. |
| Notion | ✔ Built in | dateAdd(date, months, "months")Use dateSubtract or a negative number to go back. |
| Excel | =EDATE(DATE(2024, 1, 31), 1) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =EDATE(DATE(2024, 1, 31), 1) | open sheets.new ↗ |
| Airtable | DATEADD(DATETIME_PARSE("2024-01-31", "YYYY-MM-DD"), 1, 'months') | |
| Notion | dateAdd(parseDate("2024-01-31"), 1, "months") |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
start_date | The date to start from. |
months | Months to add; negative goes back. Decimals are truncated, so 1.9 means 1. Use 12 for a year. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=EDATE(DATE(2024, 1, 31), 1) | 2024-02-29 | February has no 31st, so the result is its last day. | |
=EDATE(DATE(2024, 3, 31), -1) | 2024-02-29 | Negative months go back. | |
=EDATE(DATE(2023, 5, 10), 12) | 2024-05-10 | 12 months = one year. | |
=EDATE(TODAY(), 6) | Six months from today | Typical for renewal and review dates. |
Examples use Excel / Google Sheets syntax unless noted.
How EDATE works
Adding 30 to a date is not the same as adding a month: months have 28 to 31 days. EDATE moves by calendar months and keeps the day of the month, so a subscription that starts on the 15th renews on the 15th. If the target month is shorter, it uses the last day: 31 January + 1 month is 29 February in a leap year and 28 February otherwise.
Note that month ends are not “sticky”. EDATE("2024-02-29", 1) is 29 March, not 31 March. If you always want the month end, use EOMONTH instead. In Excel the result is a plain serial number until you format the cell as a date.
Airtable's DATEADD and Notion's dateAdd do the same job with a unit argument, and also accept 'years', 'weeks' and 'days'. Both clamp to the end of the month the same way EDATE does.
Frequently Asked Questions
- How do I add years to a date?
- Add 12 months per year:
=EDATE(A2, 12 * 5). Airtable and Notion accept ayearsunit directly.