EDATE in Excel: Use It for Months, Not Days

Formulas & functions · Updated November 22, 2026

Excel’s EDATE function moves a date forward or backward by a number of months, not by a number of days. To add an exact number of days, add that number to the date instead: if A2 contains July 1, 2026, =A2+30 returns July 31, 2026.

What EDATE Does

EDATE is for calendar-month calculations: a date one month later, three months earlier, or a year later. Its two inputs are a starting date and a number of months. A positive month count moves forward; a negative count moves backward; zero returns the starting date. The result is a date serial that Excel can display as a date.

With July 1, 2026 in A2, this formula returns August 1, 2026: =EDATE(A2,1). With the same starting value, this formula returns April 1, 2026: =EDATE(A2,-3). The month count can be a number typed in the formula or a reference to another cell.

The important distinction is that a month is not a fixed number of days. Calendar months have 28, 29, 30, or 31 days, so EDATE cannot be used to mean “add 30 days” or “add 90 days.” Choose the operation that matches the real rule you are calculating.

How to Add Days in Excel

Excel stores dates as serial numbers, so adding a whole number to a date advances that many days. If A2 contains July 1, 2026, this formula adds 30 days and returns July 31, 2026: =A2+30. It counts the next calendar day as one day after the starting date; it does not count July 1 as day one.

If the number of days is in B2 instead, the formula can refer to that cell. With July 1, 2026 in A2 and 30 in B2, =A2+B2 returns July 31, 2026. This is useful for due dates, delivery estimates, or other intervals that are defined as a fixed number of calendar days. If B2 changes, the result updates automatically.

To find the number of days between two dates, subtract the earlier date from the later date. With July 1, 2026 in A2 and July 31, 2026 in B2, =B2-A2 returns 30. If your business rule counts both the start date and end date as included days, add one to the difference; first confirm that inclusive counting is actually required.

Month-End Dates and Shorter Months

EDATE tries to keep the same day number in the destination month. If that day does not exist, it returns the last day of the destination month. This behavior matters for dates near the end of a month, and it is one reason the result may not be the same day number as the original date.

With January 31, 2026 in A2, =EDATE(A2,1) returns February 28, 2026, because February has no 31st. With January 31, 2024 in A2, the same formula returns February 29, 2024, because 2024 is a leap year. Starting from March 31 and moving back one month similarly lands on February’s final day.

This is usually appropriate for monthly schedules such as statements or recurring review dates when the intended rule is “the same day of the month, or the last day if that day is unavailable.” It may not match a policy that requires every date to be the first of the month, the final day of the month, or a fixed number of days apart. Define that rule before choosing a formula.

Entering Dates and Month Counts Correctly

For the most reliable results, enter a real Excel date in the start-date cell and apply a date number format so the result is easy to read. A date that only looks like a date but is stored as text may cause an error or an unexpected result. Imported data is a common source of text dates, especially when day and month order differs between the source file and your regional settings.

On Excel for Microsoft 365 for Windows, you can check or change how a result is displayed from Home > Number Format. Changing the format changes the display, not the underlying date value. Excel for Mac and Excel for the web also support EDATE; the ribbon layout can differ, but the function’s basic behavior is the same.

The months argument is a count of months, not a date or a day count. If you calculate it in another cell, make sure the cell contains the intended whole-month count. Microsoft documents that a non-integer month value is truncated to an integer, so using decimal month counts is not a sound way to approximate days. Use date addition for day-based intervals instead.

Choosing Between EDATE, Date Addition, and Other Date Rules

Use EDATE when the interval is expressed in calendar months: for example, a payment due one month after an invoice date or a review scheduled six months after the previous review. With January 15, 2026 in A2, =EDATE(A2,6) returns July 15, 2026. The number of elapsed days in that interval depends on the months crossed.

Use ordinary addition when the interval is explicitly a number of calendar days. With August 1, 2026 in A2, =A2+90 returns October 30, 2026. That is 90 days after August 1; it is not the same as adding three calendar months. A 90-day deadline and a three-month deadline can therefore have different results.

Some schedules use business days rather than calendar days, excluding weekends and sometimes holidays. Neither EDATE nor simple date addition automatically applies that rule. Excel has other date functions for workday calculations, but you need to specify the appropriate weekend and holiday rules for your situation. Do not substitute a monthly calculation when the requirement is a fixed number of working days.

Common EDATE Problems

  • The result looks like a number. Excel dates are serial values. If a result cell displays a number, select a date format from Home > Number Format. Formatting changes the appearance, not the calculation.
  • Excel returns an error. Check whether the starting value is a valid date rather than text, and whether the month count is a usable number. A text date imported from another system may need to be converted before EDATE can process it reliably.
  • The result is at month-end. This is expected when the target month lacks the original day number. January 31 plus one month lands on the last day of February, not a nonexistent February 31.
  • The answer is one day off from a deadline count. Confirm whether the rule counts elapsed days or counts the start date as day one. Date subtraction measures the elapsed interval; inclusive counting generally adds one when that is the defined convention.
  • The formula appears as text instead of calculating. Check that the cell is not formatted as Text and that the formula begins with an equals sign. After correcting the format, re-enter the formula if needed.

When checking an unexpected result, verify the stored start date and the actual value of the month-count cell, not just what the cells appear to show. A number format can hide a time or make a serial date look unfamiliar, while a displayed date can still be text. Correct inputs are more important than changing the formula repeatedly.

Practical Examples for Recurring Dates

For a monthly renewal, put the original renewal date in A2 and use a one-month increment. With May 20, 2026 in A2, =EDATE(A2,1) returns June 20, 2026. If you need the next renewal after several months, enter that whole-month interval in the formula or a separate input cell. Keeping the interval in a cell makes the schedule easier to adjust.

For a date one year later, use 12 months rather than assuming that every year contains exactly 365 days. With February 29, 2024 in A2, =EDATE(A2,12) returns February 28, 2025, because the following year has no February 29. That result follows EDATE’s month-end rule. If a contract, policy, or application defines an anniversary differently, apply that definition rather than assuming Excel’s result is automatically the required one.

For a fixed-day waiting period, keep the rule in days. With October 1, 2026 in A2 and 45 in B2, =A2+B2 returns November 15, 2026. If a schedule needs both an exact-day offset and a calendar-month offset, calculate each according to its own rule and compare the results; they need not coincide.

Frequently Asked Questions

Can EDATE add days in Excel?
No. EDATE moves a date by a number of calendar months. To add a set number of calendar days, add that whole number to the date value, such as =A2+10. With October 1, 2026 in A2, it returns October 11, 2026.

What formula adds one month to a date?
Use EDATE with a month count of 1. With November 12, 2026 in A2, =EDATE(A2,1) returns December 12, 2026. If the matching day is missing from the next month, the result is the last day of that month.

Why does EDATE return February 28 instead of March 2?
EDATE preserves the day number when possible and uses the target month’s final day when the original day does not exist. Thus, January 31 plus one month is February 28 in 2026. It does not roll the extra days into March.

How do I subtract a month from a date?
Use a negative month count. With August 31, 2026 in A2, =EDATE(A2,-1) returns July 31, 2026. If the previous month is shorter than the starting date’s day number, EDATE returns that month’s final day.

Is EDATE different from adding 30 days?
Yes. EDATE follows calendar months, whose lengths vary, while adding 30 advances exactly 30 calendar days. For example, from July 1, 2026, one month later is August 1, while 30 days later is July 31. Use the one that matches the stated interval.

Related

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.