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.
=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
- 01A2 holds the start date, for example 2026-01-15.
- 02EDATE(A2,3) moves the date three months forward and returns 2026-04-15 as a serial number.
- 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.
- 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
=EDATE(A2,3)=EDATE(A2,3)-- PostgreSQL
SELECT (start_date + INTERVAL '3 months')::date AS renewal_date
FROM contracts;
-- MySQL: DATE_ADD(start_date, INTERVAL 3 MONTH)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.