Dates & Calendars

How to Add Days, Weeks, Months or Years to a Date in Excel

Add or subtract days in Excel with simple arithmetic, months with EDATE, years with EDATE or DATE, working days with WORKDAY — and avoid the month-end traps.

How to Add Days, Weeks, Months or Years to a Date in Excel
In this article
  1. Try it without a spreadsheet
  2. Adding or subtracting days
  3. Adding months: EDATE
  4. Adding years
  5. Adding a mix: years, months and days
  6. Adding working days: WORKDAY
  7. Adding hours and minutes
  8. Common mistakes
  9. Example: invoice due dates
  10. Today, and dates that move
  11. Adding days in other tools
  12. How Excel stores dates
  13. Frequently asked questions
  14. Sources

In Excel, a date is a number. Adding days is simple addition: =A2+30 gives the date 30 days after A2. To add days to a date in Excel for months, use =EDATE(A2,3). For years, use =EDATE(A2,12*5). For working days, use =WORKDAY(A2,10). Google Sheets uses these same formulas.

Try it without a spreadsheet

Add or subtract any mix of years, months, weeks and days from a date and see the exact result:

Loading the calculator…

Adding or subtracting days

Excel stores dates as serial numbers — 1 January 1900 is 1, and 22 October 2026 is 46317 — so every whole number is one day. That makes day arithmetic simple:

How to Add Days, Weeks, Months or Years to a Date in Excel: A calculator, pen, and notebook on a wooden desk.
You want Formula
30 days after A2 =A2+30
90 days before A2 =A2-90
2 weeks after A2 =A2+14 or =A2+2*7
30 days from today =TODAY()+30
Days between two dates =B2-A2

If the result shows as a number such as 46347, format the cell as a date (Ctrl+1 → Date). If it shows a date when you wanted a number of days, format it as Number.

Adding months: EDATE

=EDATE(A2, 3)

EDATE moves a date by whole calendar months. It keeps the day of the month. If that day does not exist in the target month, it uses the last day. For example, =EDATE(DATE(2026,1,31),1) results in 28 February 2026. Use a negative number to go back in time. Never just add 30 days for “one month”; that is not how you add days to date in Excel. Months have 28 to 31 days. This causes the result to drift.

Wooden blocks forming a perpetual calendar with days and months.

For the last day of a month, use EOMONTH: =EOMONTH(A2,0) is the end of A2’s month and =EOMONTH(A2,1) the end of next month — handy for “payment due at the end of the following month”.

Adding years

The cleanest way uses =EDATE(A2, 12*N). It handles February 29th correctly. It becomes February 28th in a common year. Another way to add days to date Excel is =DATE(YEAR(A2)+N, MONTH(A2), DAY(A2)). This also works. But it turns February 29th into March 1st. This happens in a common year. DATE rolls an invalid day to the next month.

Adding a mix: years, months and days

=EDATE(A2, 12*years + months) + days

Apply the years and months first and the days last, as most date calculators do — the order matters at month ends. In 2027, 30 January + 1 month + 1 day gives 28 February + 1 day = 1 March, while adding the day first (31 January) and then the month gives 28 February. Pick one order and use it consistently.

Adding working days: WORKDAY

=WORKDAY(A2, 10, $E$2:$E$12)

This skips weekends and the holiday dates listed in E2:E12. The start date counts as day 0, so one working day after a Friday is the following Monday. For weekends other than Saturday–Sunday, use WORKDAY.INTL. Details in counting business days in Excel.

Adding hours and minutes

Times are fractions of a day: 1 hour is 1/24, 1 minute is 1/1440. Add 6 hours with =A2+6/24 or =A2+TIME(6,0,0). Format the result as date and time (yyyy-mm-dd hh:mm) to see both.

Common mistakes

  • Text dates: “23/10/2026” typed into a US-locale sheet is text, and =A2+30 gives #VALUE!. Type ISO dates (2026-10-23) or fix the locale.
  • Off-by-one: “within 30 days of 1 March” usually means up to 31 March (1 March + 30). If both days must be counted, use +29.
  • Dates before 1900: Excel cannot calculate with them.

Example: invoice due dates

Invoice date Terms Formula Due date
2026-10-22 Net 30 =A2+30 2026-11-21
2026-10-22 Net 60 =A3+60 2026-12-21
2026-10-22 End of next month =EOMONTH(A4,1) 2026-11-30
2026-10-22 10 working days =WORKDAY(A5,10) 2026-11-05

If a due date must not fall on a weekend, wrap it: =WORKDAY(A2+30-1,1) moves a weekend date forward to the next working day while leaving weekday dates unchanged.

A person typing on a laptop, with images displayed on the screen.

Today, and dates that move

TODAY() changes every day, so any formula built on it changes too. To freeze a date — for example the date an order was placed — press Ctrl+; in the cell to type today’s date as a fixed value. Use TODAY() only for things that should move, like “days remaining”.

Adding days in other tools

  • Google Sheets: identical formulas — =A2+30, EDATE, EOMONTH and WORKDAY all work.
  • Python: from datetime import date, timedelta; date(2026,10,22) + timedelta(days=30) gives 2026-11-21. For months, use the dateutil package’s relativedelta(months=1).
  • JavaScript: const d = new Date(2026, 9, 22); d.setDate(d.getDate() + 30); — months are numbered from 0, a common source of bugs.
  • SQL: DATEADD(day, 30, order_date) in SQL Server, order_date + INTERVAL '30 days' in PostgreSQL, DATE_ADD(order_date, INTERVAL 30 DAY) in MySQL.

How Excel stores dates

Excel for Windows counts days from January 1, 1900, as day 1. Times are decimal parts. So, 46317.5 is noon on October 22, 2026. Older Mac workbooks used the 1904 date system. The same date is 1,462 lower there. If dates jump by four years when you copy, check “File → Options → Advanced → Use 1904 date system.” This applies to how you add days to date in Excel. Google Sheets counts from December 30, 1899. Its serial numbers match Excel’s for dates after February 1900.

A hand circling a date on a calendar with a pen.

Frequently asked questions

How do I add 30 days to a date in Excel?

=A2+30, then format the cell as a date.

How do I add months to a date?

=EDATE(A2, number_of_months).

How do I add years to a date?

=EDATE(A2, 12*number_of_years).

How do I subtract days from today?

=TODAY()-90 gives the date 90 days ago.

Sources

Photo of Yasir Hafeez

Written by

Yasir Hafeez is the founder and editor of ItsAgeCalculator. He builds the calculators, writes and checks the guides and articles, and tests every result against fixed date rules. He also runs OmniMatrics, a site of everyday calculators and converters.

More articles · Editorial policy · Spotted a mistake? Let us know.

Age tools