How to Add Months to a Date in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: EDATE returns the date a set number of months before or after a start date. The formula is =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)

A step-by-step example

Cell A2 holds a start date of January 15, 2026.

A
1Start date
21/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

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.

Hint: EDATE(A2, 3).

Exercise 2: Two months earlier

Write a formula that returns the date 2 months before the date in A2.

Hint: use a negative number of months.

What to learn next

Syntax and rules in this guide were checked against Google's EDATE help page. See all guides.