TodayFree forever - no sign-up, no paid plans

How to add days in Excel - simple formulas and EDATE

By Daniel Mercer · Updated November 3, 2026

Open the Date Calculator

Excel makes adding days to a date almost suspiciously easy, because underneath, an Excel date is just a number. This guide covers the plain-addition formula, the formatting trap that makes correct answers look wrong, and the separate EDATE function you need the moment the thing you are adding is months rather than days.

Why plain addition works

Excel stores every date as a serial number: the count of days since the end of 1899. November 22, 2026 is stored as 46348. That is why =A1+45 adds exactly 45 days to the date in cell A1 - the formula adds 45 to the serial number, giving 46393, which is January 6, 2027. There is no special date function for days because arithmetic already does the job, month ends, leap years and all. The calendar complexity is hidden inside the serial system.

The everyday formulas are these:

JobFormulaExample result
Add days to a date=A1+45Nov 22, 2026 becomes Jan 6, 2027
Subtract days=A1-45Nov 22, 2026 becomes Oct 8, 2026
Days from today=TODAY()+30Always 30 days after the current date
Add weeks=A1+7*66 weeks later, same weekday
Add months=EDATE(A1,3)Same day of month, 3 months on

If you are adding days away from a spreadsheet, our date calculator does the same arithmetic and shows the weekday of the result, which is the detail spreadsheets make you work for. And if you need the gap between two dates you already have rather than a new date, the days between calculator on the homepage counts it directly.

How to add days in Excel with EDATE - a signed contract with a start date

The number-instead-of-a-date trap

The most common Excel date complaint is a formula that returns something like 46393 instead of a date. Nothing has gone wrong: the calculation is correct, but the result cell is formatted as a general number, so Excel shows the raw serial. Select the cell, apply any date format, and 46393 becomes January 6, 2027. The reverse trap also exists - a cell formatted as a date that holds text. If your formula returns #VALUE, check whether the "date" you are adding to is really a date: real dates right-align in the cell by default and change appearance when you change their format; text typed to look like a date does neither. Rebuild doubtful dates with =DATE(2026,11,22), which takes year, month and day as separate numbers and cannot be misread by any locale.

EDATE - when the unit is months

Plain addition adds days, and days only. The moment a schedule says "monthly", "every 3 months" or "one month from signing", the function you need is EDATE: =EDATE(A1,1) adds one month, keeping the same day of the month. EDATE also handles the month-end problem the standard business way, by clamping: =EDATE(DATE(2026,1,31),1) returns February 28, 2026, because February has no 31st. In a leap year the same formula returns February 29. Use a negative second argument to go backward, and any whole number for longer jumps - =EDATE(A1,12) is the clean way to add a year of months.

Do not substitute one for the other. =A1+30 and =EDATE(A1,1) differ by up to three days depending on the months involved - from January 31, 2026 they land on March 2 and February 28 respectively, a two-day gap. Our guide on why adding 30 days is not adding one month works through that comparison in full, and the month-end problem guide explains the clamp and the drift it causes in recurring schedules.

Building formulas that survive real spreadsheets

Three habits keep date formulas honest in shared files. First, keep the number of days in a cell of its own and reference it - =A1+$C$1 - so the assumption is visible and adjustable instead of buried inside fifty formulas. Second, use DATE() for any fixed date a formula depends on, like a contract start, because typed dates can be misread when a file crosses between US and European locale settings: 02/03/2026 is February 3 in one and March 2 in the other. Third, sanity-check one row by hand against a calendar before filling a formula down ten thousand rows. Date errors scale silently; a one-row check is the cheapest insurance in the whole spreadsheet.

When the result looks wrong

Three display problems account for nearly every "the formula is broken" moment. First, the result shows as a plain number like 46393: the formula worked, but the cell is formatted as a number, so you are seeing the raw serial. Format the cell as a date and January 6, 2027 appears. Second, the addition does nothing or errors: the start "date" is probably text that merely looks like a date, often because it was imported or typed with an apostrophe. Real dates right-align and respond to number formatting; text does neither. Re-enter it as a genuine date, or convert it with =DATEVALUE(A1). Third, results drift when copied: if one start date should drive a whole column of milestones, anchor it with dollar signs - =$A$1+B2 - so every row adds its own number of days to the same fixed start instead of to the row above. That anchored pattern is the cleanest way to build a whole schedule of future dates from a single trigger date.

Frequently asked questions

Why does my Excel date formula show a number like 46393?

The formula worked - the cell is just formatted as a number. Excel stores dates as day counts, and 46393 is the stored form of January 6, 2027. Select the cell and apply a date format, and the number turns into the date you expected.

How do I add months to a date in Excel instead of days?

Use EDATE: =EDATE(A1,3) adds 3 months to the date in A1, keeping the same day of the month and clamping to the last day of the month when needed. Adding 90 with plain arithmetic is not the same thing - it adds 90 days, which can land two or three days away from the 3-month answer.

How do I add the same number of days to a whole column of dates?

Write the formula once with a fixed reference to the number of days, for example =A1+$C$1, then fill it down the column. The dollar signs keep the days cell fixed while the date cell moves row by row.

Why does my formula return #VALUE?

Almost always because the "date" in the cell is actually text - typed in a format Excel did not recognise, or imported from another system. A real date right-aligns and can be reformatted; text cannot be added to. Retype the date in an unambiguous format or rebuild it with DATE(year, month, day).

Can I subtract days with the same method?

Yes. =A1-45 subtracts 45 days, and =EDATE(A1,-2) goes back 2 months. Subtraction follows the same rules as addition, including EDATE's clamping at month end.

Related guides

How to add days to a date in Google Sheets

The same formulas in Sheets, plus its own locale traps.

How to add business days in Excel with WORKDAY

Skip weekends and holidays automatically.

Adding months to a date - the month-end problem

The clamp rule behind EDATE, and the drift it causes.

How to add days to a date

The by-hand method these formulas automate.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.