How to Add Months to a Date in Google Sheets
=EDATE(start_date, months). A positive number goes forward and a negative number goes back.
What EDATE does
Adding 30 to a date moves it 30 days, which is not the same as one month. EDATE moves by calendar months, which suits subscription renewals, payment schedules and contract ends.
EDATE syntax
=EDATE(start_date, months)
start_date: the date to calculate from. Use a cell reference to a date, or a function that returns a date such as DATE.months: how many months to move. Positive values go forward, negative values go back. Decimals are truncated, so2.6works as2.
A step-by-step example
Cell A2 holds a start date of January 15, 2026.
| A | |
|---|---|
| 1 | Start date |
| 2 | 1/15/2026 |
Dates in the tables are shown in month/day/year order. The results do not depend on your display format.
=EDATE(A2, 3)
This returns April 15, 2026: three months after January 15. For a date in the past, use a negative number:
=EDATE(A2, -2)
This returns November 15, 2025.
The typed-date trap
Google's help page warns that EDATE does not convert typed dates the way a cell does. EDATE(10/10/2000, 1) is read as a division, not a date. Point to a cell that contains the date, or build the date with DATE(2000, 10, 10).
Month ends
The help page does not say how EDATE treats dates at the end of a month, such as the 31st. For last-day-of-the-month results, the page points to EOMONTH, and it is worth testing your own month-end cases.
Common mistakes
- Typing the date inside the formula. Use a cell or DATE.
- The result shows as a number. Format the cell as a date.
- Using +30. A month is not always 30 days.
Try it yourself
Use the date above (A2). Type your formula into the box, starting with =, then press Check.
Exercise 1: Three months later
Write a formula that returns the date 3 months after the date in A2.
Exercise 2: Two months earlier
Write a formula that returns the date 2 months before the date in A2.
What to learn next
- DATE: build a date from a year, month and day.
- Days between two dates: three ways to count the gap.
- TODAY: return the current date.
- YEAR, MONTH, DAY: pull parts out of a date.
- EOMONTH: returns the last day of a month.
Syntax and rules in this guide were checked against Google's EDATE help page. See all guides.