Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inEDATE(start_date, months)
Returns a serial number — format the cell as a date.
Google Sheets✔ Built inEDATE(start_date, months)
Airtable✔ Built inDATEADD(date, months, 'months')
Also clamps to the end of the month, like EDATE.
Notion✔ Built indateAdd(date, months, "months")
Use dateSubtract or a negative number to go back.
Try EDATE with your own values
Result (as Excel & Google Sheets return it)
Thu, Feb 29, 2024 2024-02-29 ยท stored as serial number 45351 in Excel and Sheets
Your formula, ready to paste
Excel=EDATE(DATE(2024, 1, 31), 1) open excel.new ↗
Google Sheets=EDATE(DATE(2024, 1, 31), 1) open sheets.new ↗
AirtableDATEADD(DATETIME_PARSE("2024-01-31", "YYYY-MM-DD"), 1, 'months')
NotiondateAdd(parseDate("2024-01-31"), 1, "months")

Arguments

ArgumentWhat it means
start_dateThe date to start from.
monthsMonths to add; negative goes back. Decimals are truncated, so 1.9 means 1. Use 12 for a year.

Examples

FormulaResultWhyCopy
=EDATE(DATE(2024, 1, 31), 1)2024-02-29February has no 31st, so the result is its last day.
=EDATE(DATE(2024, 3, 31), -1)2024-02-29Negative months go back.
=EDATE(DATE(2023, 5, 10), 12)2024-05-1012 months = one year.
=EDATE(TODAY(), 6)Six months from todayTypical 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 a years unit directly.

Part of the Date & Time functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.