Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to add months to a date in Excel and Google Sheets
Topic:Date arithmeticExcel & Google Sheets
=EDATE(A2, 3)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Put the start date in A2.
- 2Enter =EDATE(A2, 3) to add three months; use a negative number to go back.
- 3Format the result as a date if it shows as a number.
Tips
- For the end of the month a number of months away, use EOMONTH instead.
- To add days rather than months, just add a number: =A2+30.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I add a year to a date?
Add 12 months: =EDATE(A2, 12). EDATE keeps the same day of the month.
More on Date arithmetic
See all →Reference
TODAY / DATEDIF
Work with the current date and measure the gap between two dates.
How-toHow to calculate age from a date of birth
Calculate completed years at an explicit as-of date with DATEDIF and numeric DATE inputs, avoiding ambiguous date text and changing examples.
ReferenceDATEDIF
Calculates the difference between two dates in years, months, or days using a unit code string.
How-toHow to calculate days between two dates
Subtract one date from another to get the number of days, or count working days with NETWORKDAYS. Works in both apps.
How-toHow to flag overdue dates
Mark rows whose due date has passed by comparing it to TODAY() with IF. Works the same in Excel and Google Sheets.
How-toHow to calculate age from a birthday
Use DATEDIF with TODAY() to calculate a person's exact age in years from a birth date cell in Excel and Google Sheets.