EDATE in Excel: Add Months to a Date, With Examples

Formulas & functions · Updated November 18, 2026

To add calendar months to a date in Excel, use =EDATE(start_date, months). For example, with a date in A2 and the number of months to add in B2, enter =EDATE(A2,B2); Excel returns the date that many months before or after the starting date.

What EDATE Does

EDATE shifts a date by a specified number of calendar months. It is useful for tasks such as creating monthly reporting dates, calculating renewal dates, laying out payment schedules, or finding a date a set number of months in the past. Unlike adding a fixed number of days, it follows the calendar: one month after March 15 is April 15, even though those months have different lengths.

The function has two arguments: start_date is the starting date, and months is the number of months to move. A positive number moves forward; a negative number moves backward; zero returns the starting date. In Microsoft 365 for Windows, EDATE is a built-in worksheet function. You do not need to enable an add-in to use it.

EDATE returns an Excel date value, which is stored as a serial number and displayed according to the cell’s number format. If the result looks like a number rather than a date, the calculation may still be correct—the cell may simply need date formatting.

How to Enter the Function

Put a genuine Excel date in one cell and the month offset in another. For example, assume A2 contains January 15, 2025, and B2 contains 3. In C2, enter =EDATE(A2,B2). The result is April 15, 2025. If B2 contains -3 instead, the result is October 15, 2024.

You can also supply a date with Excel’s DATE function, which avoids ambiguity between regional date formats. With no worksheet inputs needed, enter =EDATE(DATE(2025,1,15),3). The result is April 15, 2025. DATE uses year, month, and day arguments in that order; EDATE then advances three calendar months.

To enter the function:

  1. Enter the starting date and month offset in separate cells, if you want them to be easy to change.
  2. Select the cell where the answer should appear and type the EDATE formula, using commas between arguments.
  3. Press Enter. If needed, format the result as a date using Home > Number Format dropdown > Short Date, or choose another date format.

In Excel for Mac, the function and formula syntax are the same. Ribbon labels can vary slightly by release, but date formatting is available from the Home tab’s number-format controls. Excel for the web also supports EDATE; the function works the same way, though the ribbon layout may differ.

Month-End Dates and Shorter Months

EDATE adjusts the day when the target month does not contain the starting day. For example, January 31 plus one month cannot land on February 31, so the result is the last valid day of February. In a non-leap year, that is February 28; in a leap year, it is February 29. This behavior is often exactly what a user wants when moving a date forward by one month.

With no worksheet inputs, =EDATE(DATE(2024,1,31),1) returns February 29, 2024, because 2024 is a leap year. The corresponding result for the same starting day in 2025 is February 28, 2025. EDATE does not roll the extra days into March.

One subtle consequence matters when building a sequence. If you start with January 31 and repeatedly add one month to the previous result, the dates can become February 28, March 28, and April 28. Each step uses the date in the previous row, so the day has already been adjusted. If instead every date is calculated from the original January 31 anchor, the sequence is February 28, March 31, and April 30. Decide whether you want a rolling sequence or dates anchored to the original start.

For an anchored schedule, assume the original date is in A2 and the sequence number 1, 2, 3, and so on is in B2:B4. In C2, enter =EDATE($A$2,B2) and fill down. If A2 is January 31, 2025, the sequence returns February 28, March 31, and April 30, 2025. The absolute reference keeps the starting date fixed as the formula is copied.

Using Negative and Decimal Month Values

Negative month counts are valid and useful for backdating. If A2 contains July 20, 2025, then a formula using -6 as the month argument returns January 20, 2025. You can type a negative number directly or store it in a cell, just as you would with a positive offset.

EDATE truncates a fractional month argument to an integer; it does not convert the fraction into a number of days. For example, a month value of 2.8 is treated as 2 months, while -2.8 is treated as -2 months. Avoid fractional values if the intended period is not a whole number of calendar months. For a duration such as 45 days, use day-based date arithmetic instead, with the understanding that days and calendar months are different kinds of intervals.

A zero offset leaves the date unchanged. This can be handy when the number of months is supplied by a control cell, because the same formula can handle zero, positive, and negative offsets without needing separate formulas.

EDATE Compared With EOMONTH and Adding Days

Choose EDATE when you want to preserve the day of the month where possible. Choose EOMONTH when you specifically need the last day of a month. For instance, a date in the middle of a month shifted with EDATE stays near the middle; EOMONTH instead returns the target month’s final date.

With a starting date in A2 and a month offset in B2, =EOMONTH(A2,B2) returns the last day of the month that many months away. If A2 is January 15, 2025, and B2 is 1, the result is February 28, 2025. By contrast, =EDATE(A2,B2) returns February 15, 2025. Both functions accept negative offsets as well.

Adding a number directly to a date counts days, not months. If A2 contains January 15, 2025, then =A2+30 returns February 14, 2025. It does not mean “one month later,” because months have different lengths. Use EDATE for calendar-month rules and ordinary addition for a fixed number of days.

Common Uses for EDATE

EDATE can support many routine planning tasks, provided the schedule is genuinely defined in calendar months. Common examples include:

  • Creating monthly review dates from an initial project date.
  • Calculating a date six months before or after a milestone.
  • Generating periodic follow-up or renewal dates.
  • Building a sequence of reporting periods while keeping each date tied to an original anchor.
  • Finding a date for a spreadsheet model that uses monthly intervals.

For example, if a review is due every three months from a date in A2, put 3 in B2 and use EDATE with those cells. To generate later reviews, use offsets of 3, 6, 9, and 12 months from the original date. This makes the intended interval visible and avoids treating each previous result as the new anchor by accident.

EDATE calculates dates; it does not decide what a contract, policy, or organization means by a “month.” Rules may specify the last business day, a particular day of the month, or a special adjustment when a date falls on a weekend or holiday. Those rules require additional logic and should be modeled explicitly rather than assumed to be part of EDATE.

Troubleshooting Incorrect or Unexpected Results

If EDATE returns a serial number such as 45672, first check the result cell’s format. Select the cell and choose a date format from Home > Number Format dropdown. Changing the display format does not change the underlying date value; it changes how Excel shows it.

If the result is #VALUE!, check whether the starting value is a valid date and whether the month argument is numeric. Dates imported from another system may be stored as text, especially when day and month order differs between regional settings. A cell that looks like a date is not necessarily a date value. Re-enter it as a date, or convert the source data using an appropriate import or conversion method before applying EDATE.

If the result is one month different from what you expected, check the starting day and the target month’s length. A starting date on the 29th, 30th, or 31st may be adjusted to the final day of a shorter target month. Also check whether the formula refers to the original date or to the prior row in a sequence; those approaches can produce different later results.

When typing dates directly into formulas or cells, regional settings can affect how text such as 03/04/2025 is interpreted. DATE(year,month,day) is a more explicit way to construct a date in a formula. For worksheet entry, use a recognized date format for the computer’s locale or import dates with the correct regional interpretation.

Frequently Asked Questions

Does EDATE add calendar months or a fixed number of days?
EDATE adds calendar months. It does not treat a month as 30 days or any other fixed day count. Use ordinary date addition when you need an exact number of days.

What happens when I add one month to January 31?
EDATE returns the last valid day of February: February 28 in a non-leap year or February 29 in a leap year. It does not return a date in March.

Can EDATE subtract months?
Yes. Use a negative month argument, such as -3, to move three calendar months backward. The same end-of-month adjustment applies when the destination month is shorter.

Why does EDATE show a number instead of a date?
Excel stores dates as serial values. Apply a date number format to the result cell; the displayed number should then appear as a readable date.

How is EDATE different from EOMONTH?
EDATE aims to preserve the starting day of the month when possible. EOMONTH returns the final day of the target month, regardless of the starting day.

Can I use EDATE in Excel for Mac or the web?
Yes. EDATE is available in current Excel for Mac and Excel for the web, and its formula syntax is the same. Ribbon layout and date-format controls may look different from Excel for Microsoft 365 on Windows.

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.