Excel EDATE With Days Instead of Months: What to Use

No. EDATE adds months, not days; if A2 contains 10-Feb-2024 and B2 contains 30, use =A2+B2 to get 11-Mar-2024. For working days rather than calendar days, use WORKDAY instead.

Why EDATE does not accept days

EDATE is designed to move a date forward or backward by a number of calendar months. Its two arguments are a starting date and a month count, so changing the second argument to 30 means 30 months, not 30 days. There is no setting that changes EDATE into a day-based function.

This distinction matters because a month is not a fixed number of days. Calendar months can have 28, 29, 30, or 31 days, while a day-based interval is a specific count of dates on the calendar. If a contract says payment is due 30 days after an event, adding 30 is usually the appropriate interpretation. If it says one month after the event, EDATE is generally the better fit.

Excel stores valid dates as serial numbers and displays them according to the cell’s number format. Adding a whole number to a date serial moves the date by that many calendar days. EDATE, by contrast, calculates a target month and handles dates near the end of a month according to that month’s length.

Add calendar days with simple date arithmetic

For a variable number of days, put the starting date in A2 and the number of days to add in B2. The result is the date B2 calendar days after A2:

With A2 set to 10-Feb-2024 and B2 set to 30, =A2+B2 returns 11-Mar-2024. The arithmetic is 10 February plus 30 days; 2024 is a leap year, but February 29 is simply one of the dates counted.

This approach includes Saturdays, Sundays, and holidays. If the day count is fixed rather than stored in a cell, you can add that number directly. With A2 set to 5-Apr-2026, =A2+7 returns 12-Apr-2026. The result is exactly seven calendar days later.

To move backward, subtract the day count. With A2 set to 20-Jun-2026 and B2 set to 10, =A2-B2 returns 10-Jun-2026. This is useful for calculating a date ten days before a deadline, delivery, or appointment.

Keep the date and day count in separate cells when the inputs may change. That makes the calculation easier to audit and lets you reuse the formula down a column. For example, copy the formula in C2 down a table where dates are in column A and day offsets are in column B; Excel adjusts the row references for each record.

Calendar days versus working days

Adding a number directly counts every calendar day. That is the right choice for many notice periods, elapsed-time calculations, and rules that explicitly say calendar days. But a result that lands on a weekend may not work for a business deadline. In that case, establish whether the rule means working days or calendar days before choosing a formula.

WORKDAY advances a date by a specified number of working days, treating Saturday and Sunday as weekends by default. With A2 set to Monday, 4-May-2026, and B2 set to 5, =WORKDAY(A2,B2) returns Monday, 11-May-2026. The starting date is not counted as the first of those five days: the count begins on the next working day.

WORKDAY can also exclude a supplied list of holidays using its optional third argument. If you use that option, keep actual holiday dates in a range and pass that range to the function. Check that the list contains Excel date values, not text labels, and confirm that the organization’s weekend pattern matches the function’s Saturday-Sunday default. For weekend patterns that differ, Excel also provides WORKDAY.INTL.

Do not use WORKDAY simply because a deadline happens to fall on a weekend unless the governing policy says to move it. Some rules require the literal calendar date, while others move a weekend or holiday deadline to a business day. The spreadsheet cannot determine which rule applies.

How EDATE behaves at month ends

EDATE is useful when the intended interval is expressed in months, such as a monthly renewal or a date one month after an invoice. If A2 contains 31-Jan-2025, =EDATE(A2,1) returns 28-Feb-2025. February has no 31st, so the result is the last valid date in the target month.

That month-end behavior is one reason EDATE is not interchangeable with adding a fixed number of days. One month after 31 January is 28 February in this example, while adding 30 days produces 2 March. Both results are mathematically valid, but they answer different questions.

EDATE can also move backward. A negative month argument moves to an earlier month, and zero leaves the date in the same month. If the source date is near the end of a month, check the returned date against the business rule you are modeling. For a recurring month-end schedule, EOMONTH may be more direct because it returns the last day of a month a specified number of months away.

Make sure Excel recognizes the starting value as a date

Date addition works reliably when the starting cell contains a real Excel date value. A cell that merely looks like a date may instead contain text, particularly when data has been copied from a website, imported from a system, or entered using a date order that conflicts with regional settings. If adding days produces an error or an unexpected result, inspect the source value before changing the formula.

One quick check is to select the cell and temporarily apply a different date or number format. In Excel for Microsoft 365 on Windows, press Ctrl+1 to open Format Cells; on Mac, press Command+1. If Excel recognizes a date serial, changing the display format should change how it appears without changing the underlying value. If the cell remains text, changing its number format alone will not convert it.

You can also enter dates with Excel’s date picker behavior or use a consistent, unambiguous date-entry method for your locale. Imported text may need to be converted through the import process or with a deliberate date-conversion formula. Avoid guessing at ambiguous strings such as 03/04/2026, which can mean different dates in different regional conventions. Check the workbook’s interpreted date and the source system’s date convention.

Format the result and handle unusual inputs

A correct calculation can look wrong if the result cell is formatted as General or Number. It may show a serial number rather than a familiar date. Select the result cell and choose a suitable date format from the Number Format controls on the Home tab, or open Format Cells with the shortcut above. Formatting changes the display, not the calculated date.

Zero days leaves the date unchanged; a negative day count moves backward. A blank day-count cell is treated as zero in ordinary addition, so the result will match the starting date. If blanks should instead produce a blank result, use an IF check. With A2 holding the starting date and B2 the day count, =IF(B2="","",A2+B2) returns a blank when B2 is empty; if A2 is 10-Feb-2024 and B2 is 30, it returns 11-Mar-2024. The formula assumes the day-count cell is genuinely empty or contains an empty string, rather than a space.

Fractional offsets are possible because Excel stores dates with time fractions. Adding 1.5 days advances by one day and twelve hours. If the result must be a date with no time component, use whole-number day counts or explicitly remove the time portion after calculating. Also check that a date plus a negative offset does not move outside the supported date range of the workbook.

Choose the formula that matches the requirement

Before writing a date formula, translate the wording into the kind of interval it describes. The key question is not which function looks familiar, but whether the interval is in calendar days, working days, or months.

Calendar days: add or subtract a whole number, as in =A2+B2.
Working days: use WORKDAY, and include the relevant holiday list if required.
Calendar months: use EDATE, especially for monthly anniversaries or renewal dates.
Last day of a target month: consider EOMONTH when the target must be month-end.
A particular weekday or business rule: confirm the rule first; a formula cannot infer how a policy treats weekends and holidays.

This choice prevents a frequent spreadsheet mistake: using a month-based function for a deadline stated in days, or using a fixed day count for an interval stated in months. For example, a 90-day period is not necessarily the same as three calendar months. Depending on the starting date, three months can span different numbers of days.

Frequently Asked Questions

Can I use EDATE to add 30 days?
No. EDATE interprets its second argument as months, so 30 means 30 months. To add 30 calendar days, add 30 to the date value, such as =A2+30 when A2 contains the starting date.

What is the difference between EDATE and adding days?
EDATE moves to a date in another month and accounts for the number of days available in that month. Adding a number moves by that exact number of calendar days. The results can differ, especially around month ends.

How do I add business days instead of calendar days?
Use WORKDAY with the starting date and the number of working days. Its default weekend is Saturday and Sunday. Supply a holiday range if those dates should also be skipped, and verify the applicable weekend and deadline rules.

Why does my answer show a number instead of a date?
The calculation may be correct, but the result cell may be formatted as General or Number. Apply a date format using the Home tab’s number-format controls or Format Cells. If changing the format does not help, check whether the starting value is text rather than an Excel date.

Does adding 30 days include the starting date?
No. In ordinary date arithmetic, adding 30 produces the date 30 days after the starting date; the start date is day zero in that interval. If a policy counts the start date as day one, the required offset may be one day smaller, so follow the policy’s counting convention.

Bottom line

EDATE is for months, not days. For an exact calendar-day offset, add or subtract the day count from a valid Excel date; for a working-day offset, use WORKDAY and account for the relevant holidays. Choose based on the wording of the deadline or schedule, then format the result as a date and confirm that Excel recognizes the starting value correctly.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.