If A2 contains a date and B2 contains a number of calendar days, add days in Excel with =A2+B2. Use EDATE when you want to move by a number of months instead: with the same cell layout, =EDATE(A2,B2) shifts the date by B2 months, not days.
The Short Answer: Days Versus Months
The key difference is the unit of time. Excel stores dates as serial numbers, so adding a whole number to a date moves that many calendar days forward. EDATE interprets its second argument as months and aims to keep the same day of the month when the target month has that day.
For example, if A2 contains 15-Jan-2025 and B2 contains 10, =A2+B2 returns 25-Jan-2025. If A2 contains 15-Jan-2025 and B2 contains 1, =EDATE(A2,B2) returns 15-Feb-2025. The formulas may look similar, but substituting one for the other can shift a schedule by weeks.
Use date addition for a fixed number of days, such as a 14-day response period. Use EDATE for a month-based interval, such as three months after a start date. Neither formula automatically means working days; ordinary date addition counts weekends and holidays too.
How Excel Date Addition Works
Excel dates are stored as numbers, with the displayed date determined by the cell’s number format. Adding 1 advances the underlying date by one calendar day. This also means a date can be used in ordinary arithmetic, including subtraction to find the number of days between two dates.
With a start date in A2 and the number of calendar days to add in B2, enter =A2+B2 in another cell. If A2 is 15-Jan-2025 and B2 is 10, the result is 25-Jan-2025. For a fixed seven-day interval, if A2 holds the start date, enter =A2+7; a start date of 15-Jan-2025 gives 22-Jan-2025.
Negative amounts move backward. With a date in A2 and 3 in B2, =A2-B2 subtracts three calendar days; if A2 is 15-Jan-2025, the result is 12-Jan-2025. If B2 itself contains a negative number, adding it also moves backward, so choose one consistent convention for input values to prevent accidental double-negatives.
Fractions have a special meaning because Excel date-time values can include a time portion: 1 represents a full day and 0.5 represents half a day. Adding 0.5 to a date-time advances it by 12 hours. For a whole-day deadline, use whole numbers and check that the source cell does not contain an unexpected time value.
How EDATE Handles Month Changes
EDATE takes a start date and a number of months. A positive month count moves forward; a negative count moves backward. With a start date in A2 and a month count in B2, use =EDATE(A2,B2). For example, if A2 is 15-Jan-2025 and B2 is 3, the result is 15-Apr-2025. If B2 is -2, the result is 15-Nov-2024.
Month lengths do not match, so EDATE has to handle dates that do not exist in the target month. With a start date of 31-Jan-2025 in A2 and 1 in B2, =EDATE(A2,B2) returns 28-Feb-2025, the last valid day in February. In leap year 2024, moving one month forward from 31-Jan-2024 returns 29-Feb-2024. Moving from 31-Mar-2025 back one month returns 28-Feb-2025.
This month-end adjustment is useful for many monthly schedules, but it is not the same as adding a fixed number of days. One month after 31-Jan-2025 is 28-Feb-2025 with EDATE, while adding 30 days to 31-Jan-2025 reaches 2-Mar-2025. A month is a calendar unit of varying length, not a fixed number of days.
EDATE is designed to return a date serial. If the result appears as a number rather than a readable date, the calculation may still be correct: apply a date format to the result cell using Home > Number Format. The exact display depends on the chosen format and regional settings.
Choosing the Right Formula for a Real Task
Start by checking how the requirement is written. If it says days, use addition or subtraction. If it says months, use EDATE. If it says business days, use a workday function rather than either of those simple methods. A contract or process may define its own counting rules, so the spreadsheet formula should reflect those rules rather than assume them.
- Fixed elapsed days: Add or subtract a number, as with a 30-day return window.
- Calendar months: Use EDATE, as with a review date three months after a start date.
- Weekdays only: Use WORKDAY for a future or past working date, and provide a holiday list if relevant.
- Last day of a month: Use EOMONTH when the desired result is specifically the target month’s final day, rather than the same day number where possible.
Be particularly careful with the phrases one month and 30 days. For a date in January, one calendar month later may fall in February, while 30 days later may fall in late February or early March. If the requirement is unclear, confirm what the date is meant to represent before choosing the formula.
Examples for Deadlines and Recurring Dates
Suppose a task starts on 8-Apr-2025 and must be completed 14 calendar days later. With the start date in A2 and 14 in B2, =A2+B2 returns 22-Apr-2025. This counts every date in the interval, including Saturdays and Sundays; it does not count the start date as an extra day beyond the 14-day addition.
For a quarterly review, suppose A2 contains 8-Apr-2025 and B2 contains 3. The formula =EDATE(A2,B2) returns 8-Jul-2025. If the starting date is 31-Jan-2025 and the interval is one month, EDATE returns 28-Feb-2025, which is often more sensible for a monthly cycle than adding a fixed 30 days.
For a date that must always be the final day of the month, EOMONTH can be a better fit. With a starting date in A2 and an offset in months in B2, enter =EOMONTH(A2,B2). If A2 is 8-Apr-2025 and B2 is 1, the result is 31-May-2025, the last day of the month one month after April. This differs from EDATE, which returns 8-May-2025 for those inputs.
These examples assume A2 contains a real Excel date, not text that merely looks like one. Dates typed or imported under a different regional convention can be ambiguous: for example, 03/04/2025 can be read differently depending on locale. When importing data, confirm the interpretation and convert text values to genuine dates before relying on calculations.
Working Days, Holidays, and Other Alternatives
Adding days with ordinary arithmetic includes weekends and holidays. To move forward by working days while treating Saturday and Sunday as weekends, use WORKDAY. With a start date in A2 and the number of workdays in B2, enter =WORKDAY(A2,B2). If A2 is Friday, 10-Jan-2025, and B2 is 1, the result is Monday, 13-Jan-2025.
To exclude listed holidays as well, put actual holiday dates in F2:F10. With the start date in A2, the number of workdays in B2, and holidays in F2:F10, use =WORKDAY(A2,B2,$F$2:$F$10). The dollar signs keep the holiday range fixed if the formula is copied down. WORKDAY skips the start date when counting a positive number of workdays; check the intended counting convention for a particular process.
NETWORKDAYS answers a related but different question: it counts working days between two dates rather than returning a new date after a workday offset. If the start date is in A2 and the end date is in B2, =NETWORKDAYS(A2,B2) counts weekdays in the range, including both endpoints when they are weekdays. A holiday list can also be supplied as an optional argument.
WORKDAY and NETWORKDAYS use Saturday and Sunday as the weekend by default. If an organization uses a different weekend pattern, WORKDAY.INTL and NETWORKDAYS.INTL provide weekend options. These are useful for shift patterns, but the weekend code or mask must match the schedule; a regular Saturday-Sunday assumption will otherwise produce misleading results.
Common Problems and How to Fix Them
- The result is a number: Excel may be showing the date serial with a General format. Select the result cell and choose a date format from Home > Number Format.
- The formula returns an error or an unexpected result: Check whether the source is a valid Excel date or text. Imported text dates often need conversion before date arithmetic works reliably.
- The answer is a day off: Confirm whether the rule counts calendar days or working days, whether the start date is included, and whether weekends or holidays should be skipped.
- A month-end date changes: This is expected when the target month has fewer days. EDATE adjusts to a valid date in the target month; it cannot produce a nonexistent date such as 31-February.
- The same formula displays differently on another computer: The underlying date can be the same while regional date formats differ. Use an unambiguous format for display and check that imported dates were parsed correctly.
For dates before 1900, or for workbooks that use a different date system, extra care is needed. Excel workbooks can use the 1900 or 1904 date system, and the same serial number can correspond to different calendar dates between them. Most everyday modern dates in a workbook using its default system do not require special handling, but linked workbooks with different date systems should be checked.
Frequently Asked Questions
Is EDATE for adding days in Excel?
No. EDATE moves a date by months. To add calendar days, add a number to the date; use WORKDAY instead when the requirement is a specified number of weekdays.
What is the difference between adding 30 days and adding one month?
Thirty days is a fixed duration; one month follows the calendar. The results can differ because months have 28, 29, 30, or 31 days, and EDATE adjusts dates such as January 31 when the target month is shorter.
How do I add one month to a date in Excel?
If the starting date is in A2, use =EDATE(A2,1). Format the result as a date if Excel displays a serial number. When the source is near month-end, check whether EDATE’s adjustment matches the schedule you need.
How do I add business days instead of calendar days?
Use WORKDAY with the start date and the number of workdays. Add an optional holiday range to exclude listed holidays. Its default weekend is Saturday and Sunday, so use an international workday function for a different weekend pattern.
Why does EDATE return a number?
Excel stores dates as serial values, and the result cell may have General or Number formatting. Change the cell’s number format to a date; formatting changes how the value appears, not the underlying calculation.
Does adding days count the starting date?
Adding 1 moves a date to the next calendar date, so a start date plus 14 is 14 days later. Whether a deadline policy counts its first day inclusively is a separate rule; translate that rule into the offset rather than assuming the formula decides it.
Related
- Excel Merge Two Cells Into One Cell Without Losing Text
- Excel: Merge Data From Multiple Cells Into One Cell
- Excel Merge Cells Option Not Available? Causes and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Range of Values: Find the SpreadTo calculate the numerical range of values in Excel, subtract the smallest value from the largest: =MAX(A2:A7)-MIN(A2:A7). If…
- Excel Table Filter Multiple Values: Methods That WorkTo filter an Excel table for several values, open a column’s filter arrow, clear Select All, and check…
- Excel Running Total: Formulas, Tables, and TroubleshootingTo create a running total in Excel, enter your amounts in B2:B7, type =SUM($B$2:B2) in C2, and fill…
- Excel Time Plus Minutes: Formulas and FixesTo add minutes to an Excel time, add the minutes divided by 1,440: with a time in A2…
- Excel Sum a Row Based on a Column Header with SUMIFTo sum values across a row when their column headers match a label, use SUMIF: with headers in…
- Excel MAX of Two Values: Formula and ExamplesTo find the larger of two values in Excel, use =MAX(A1,B1), replacing A1 and B1 with the cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.