SheetSense

Add months to a date with EDATE

EDATE moves a date forward or back by a number of whole months and keeps the same day of the month, so it is the right tool for renewal and billing dates.

fx
=EDATE(A2,3)

The sheet: Contracts sheet: column A is Start date. You want the renewal date exactly three months later in column B.

How it works, step by step

  1. 01A2 holds the start date, for example 2026-01-15.
  2. 02EDATE(A2,3) moves the date three months forward and returns 2026-04-15 as a serial number.
  3. 03If the target month is shorter than the start day, EDATE uses the last day of that month. 2026-01-31 plus 1 month is 2026-02-28.
  4. 04A negative number of months moves the date back. Format the result cell as a date, or it shows a number such as 46127.

The same logic in four tools

Excel
=EDATE(A2,3)
Google Sheets
=EDATE(A2,3)
SQL
-- PostgreSQL
SELECT (start_date + INTERVAL '3 months')::date AS renewal_date
FROM contracts;
-- MySQL: DATE_ADD(start_date, INTERVAL 3 MONTH)
Python (pandas)
import pandas as pd

contracts["start_date"] = pd.to_datetime(contracts["start_date"])
contracts["renewal_date"] = contracts["start_date"] + pd.DateOffset(months=3)

Mistakes that break it

  • !Adding 90 to a date is not the same as adding 3 months. Months have different lengths, so use EDATE when the day of the month should stay the same.
  • !A date stored as text returns #VALUE!. Convert it with DATEVALUE or re-enter it as a real date.
  • !The months argument is cut to a whole number, so EDATE(A2,1.9) adds 1 month.
  • !Month-end dates do not round trip. EDATE(EDATE(DATE(2026,1,31),1),-1) returns January 28, not January 31.

Common questions

How do I add one year to a date in Excel?
Use =EDATE(A2,12). It handles leap years the same way as month-end clamping, so February 29 plus 12 months is February 28 of the next year.
What is the difference between EDATE and EOMONTH?
EDATE keeps the day of the month. EOMONTH always returns the last day of the month that is the given number of months away.
Why does EDATE return a number like 46127?
Excel stores dates as serial numbers. The formula is right, so apply a date format to the cell.

Got a version of this with your own ranges?

Paste it into the free translator and get the same breakdown for your exact formula. To run it against a real file, upload the CSV and describe the formula you need in a sentence.