In this article
- Try it without a spreadsheet
- Adding or subtracting days
- Adding months: EDATE
- Adding years
- Adding a mix: years, months and days
- Adding working days: WORKDAY
- Adding hours and minutes
- Common mistakes
- Example: invoice due dates
- Today, and dates that move
- Adding days in other tools
- How Excel stores dates
- Frequently asked questions
- 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:
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:

| 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.

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+30gives #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.

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’srelativedelta(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.

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.




