EDATE in Excel: Add Months, Not Days

Formulas & functions · Updated November 18, 2026

EDATE in Excel moves a date by whole calendar months; it does not add a specified number of days. If A2 contains a starting date and B2 contains the number of calendar days to add, use =A2+B2; for example, adding 30 to January 15, 2025 returns February 14, 2025. Use EDATE when you need a date a set number of months before or after another date.

EDATE Adds Months, Not Days

The name can be confusing: EDATE is a date function, but its second argument counts months, not days. A positive month count moves forward, and a negative count moves backward. This makes the function useful for recurring monthly dates such as subscription renewals, payment schedules, review dates, and anniversaries.

For instance, moving a date from January 15 to February 15 is a one-month shift, even though that interval is 31 days in 2025. Moving a date forward by 30 days is a different calculation and lands on February 14. The distinction matters whenever months have different lengths or a calculation must represent a specific number of elapsed days.

To illustrate EDATE with a concrete cell layout, put January 15, 2025 in A2 and the number 1 in B2. The formula =EDATE(A2,B2) returns February 15, 2025. The result is one calendar month later, not a fixed number of days later.

How EDATE Works

The function takes two arguments: a starting date and a number of months. In English-language Excel, the structure is EDATE(start_date, months). The start date can be a cell reference containing a valid Excel date, and the month count can be a number or a reference to a cell containing a number. EDATE is a built-in date and time function in Microsoft Excel for Microsoft 365 on Windows; it does not require an add-in.

For a practical example, enter October 31, 2025 in A2 and -2 in B2. With that layout, =EDATE(A2,B2) returns August 31, 2025. A negative month count is useful for finding a date in the past, such as a date two months before a project milestone.

Excel stores dates as serial numbers and displays them using a date format. EDATE returns a date serial too, so if the result appears as a number, the calculation may still be correct: the result cell may simply be formatted as General or Number. Apply a date format to show it as a calendar date.

When You Need to Add Calendar Days

For calendar days, ordinary addition is usually the simplest choice. Dates are stored as sequential day numbers, so adding 1 advances one day, adding 7 advances a week, and adding 30 advances 30 days. This is elapsed-day arithmetic; it does not skip weekends or holidays.

For a concrete layout, put January 15, 2025 in A2 and 30 in B2. The formula =A2+B2 returns February 14, 2025. That result is 30 days after January 15 when the starting day itself is not counted as an elapsed day.

If you need to calculate the number of days between two dates, subtract the earlier date from the later date. With March 1, 2025 in A2 and March 31, 2025 in B2, =B2-A2 returns 30. If a report instead asks how many calendar dates are included when both endpoints count, add 1: with those same cells, =B2-A2+1 returns 31. Decide whether the question is about elapsed time or an inclusive count before choosing the calculation.

Month-End Dates and Shorter Months

EDATE preserves the day number when the target month has that day. If it does not, Excel uses the last valid day of the target month. Thus, January 31 shifted forward one month becomes February 28 in 2025, while January 31 shifted forward one month in a leap year becomes February 29. This adjustment is normal behavior, not an error.

With January 31, 2025 in A2 and 1 in B2, =EDATE(A2,B2) returns February 28, 2025. Notice that EDATE does not carry the extra days into March. If you repeatedly apply EDATE to a month-end result, the chosen day can affect later results: February 28 shifted one month becomes March 28, not March 31.

If the requirement is always the last day of a month, use EOMONTH rather than EDATE. With January 15, 2025 in A2 and 1 in B2, =EOMONTH(A2,B2) returns February 28, 2025. EOMONTH moves by the specified number of months and returns the target month’s final date, regardless of the starting day. It is commonly used for month-end reporting or period closing dates.

Choosing the Right Date Calculation

Choose the function or operation based on what the date represents, rather than on which formula looks shortest. These distinctions are particularly useful when a spreadsheet mixes deadlines, recurring events, and business-day schedules:

  • Calendar days: Add or subtract a number directly from a date. This includes Saturdays, Sundays, and holidays.
  • Calendar months: Use EDATE when the target should retain the day number where possible, such as a monthly anniversary.
  • Month ends: Use EOMONTH when the target must always be the last calendar day of a month.
  • Working days: Use WORKDAY when weekends should be skipped, and provide a holiday range if relevant.

For example, a deadline 10 calendar days after a date is not necessarily the same as a deadline 10 working days later. If you are tracking a contract or service period, follow the definition used by the relevant agreement or process; spreadsheet date arithmetic cannot determine which interpretation applies.

Working Days and Holidays

WORKDAY counts forward or backward by working days, normally excluding Saturdays and Sundays. You can also supply a range of holiday dates to exclude. This is often a better fit for a business deadline than adding a fixed number to a date.

For a specific example, put Monday, March 3, 2025 in A2 and 5 in B2. With no holidays in the interval, =WORKDAY(A2,B2) returns Monday, March 10, 2025: Tuesday through Friday are four working days, and Monday is the fifth. The starting date itself is not counted as the first day. If weekends differ from Saturday and Sunday, Excel’s WORKDAY.INTL function can be used to specify a weekend pattern.

To exclude holidays, list valid holiday dates in D2:D10. With the same start date and day count in A2 and B2, and holiday dates in D2:D10, =WORKDAY(A2,B2,D2:D10) returns the fifth working day after March 3, skipping any listed holiday as well as weekends. If none of the listed holidays falls on a date that would otherwise count, the result remains March 10. Make sure the holiday cells contain actual Excel dates, not text that merely looks like dates.

Common Problems and Checks

If a result looks wrong, check the input values and display format before replacing the function. The most common issues are straightforward:

  • The result is a number. The cell may not be formatted as a date. Select it and choose a date display from Home > Number Format, or open Format Cells with Ctrl+1 on Windows. On Mac, use Command+1 to open Format Cells.
  • The input looks like a date but is treated as text. Imported data can contain text strings instead of date values. Re-enter or convert the value to a real date, then confirm Excel recognizes it as a date.
  • The result is one month away but not the expected number of days away. That is the expected difference between a calendar-month shift and a fixed-day addition. Confirm which rule the task requires.
  • A month-end date changes to an earlier day. EDATE adjusts to the final valid day in a shorter target month. Use EOMONTH if every result must be a month end.
  • A formula shows an error. Check for a missing or invalid start date and confirm the month argument is numeric. In some regional Excel settings, formula argument separators display as semicolons rather than commas; the examples here use comma separators.

EDATE also treats a fractional month count as a whole number by truncating the fraction. For predictable results, store an integer month count or explicitly decide how a fractional value should be rounded before using it. For example, a schedule expressed as 1.5 months needs a defined business rule; it cannot be interpreted as one universally correct number of days.

Using EDATE in a Schedule

A schedule becomes easier to maintain when the starting date and interval are stored separately. Put the initial date in A2 and the interval in months in B2. In C2, enter =EDATE(A2,B2); if A2 is January 15, 2025 and B2 is 3, C2 returns April 15, 2025. Changing B2 to 6 changes the result to July 15, 2025 without editing the formula.

To create later dates in a repeated schedule, a row can refer to the preceding result. If C2 contains April 15, 2025 and B2 contains 3, then in C3 use =EDATE(C2,$B$2); C3 returns July 15, 2025. The dollar signs keep the interval reference fixed when the formula is copied down. This approach works well for recurring dates, but note the month-end behavior: starting on January 31 and then basing each new date on the previous result can produce February 28, March 28, and April 28. If the rule is “the last day of every month,” use an end-of-month approach instead.

Frequently Asked Questions

Does EDATE add days or months in Excel?
EDATE adds or subtracts months. To add a number of calendar days, add that number to the date value. For working days, use WORKDAY.

How do I add 30 days in Excel?
If A2 contains the starting date and B2 contains 30, use =A2+B2. The result is 30 elapsed calendar days later, including weekends and holidays in the count.

Why does EDATE return February 28 instead of March 2?
EDATE moves to the target month and adjusts to its last valid day when the original day number does not exist. January 31 plus one month therefore lands on February’s final day rather than rolling extra days into March.

How can I get the last day of the next month?
Use EOMONTH with a starting date and a month offset of 1. Unlike EDATE, EOMONTH always returns the final calendar day of the target month.

Can EDATE calculate dates in the past?
Yes. Use a negative month count to move backward. The function applies the same month-end adjustment in either direction when the target month has fewer days than the starting date’s day number.

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.