EDATE in Excel: Meaning, Formula, and Examples

Formulas & functions · Updated November 22, 2026

EDATE in Excel means “end date” in the sense of a date a chosen number of months before or after a starting date. The EDATE function returns that date, making it useful for monthly schedules, renewal dates, and due dates; for example, it can move a date forward two calendar months without treating a month as a fixed number of days.

What EDATE means in Excel

EDATE is a date-and-time function. It calculates a date by adding or subtracting a number of calendar months from a starting date. A positive month count moves forward, a negative count moves backward, and zero returns the starting date. The result is a real Excel date value, not just text that looks like a date.

That calendar-based behavior matters because months have different lengths. Adding one month to January 15 gives a date in February, not a date 30 days later. EDATE is therefore a better fit than adding a fixed number of days when the requirement is “the same day in the next month,” subject to the target month’s length.

How the EDATE function works

EDATE takes two arguments: a starting date and the number of months to move. The starting date can be a cell reference containing a valid date, or a date produced by another function. The month count can be positive, negative, or zero. If the month count has a decimal portion, Excel truncates it to an integer before calculating.

With the starting date in A2 as January 15, 2025, and the month count in B2 as 2, enter =EDATE(A2,B2) in C2. The result is March 15, 2025. The comma separates the function’s two arguments in standard English-language Excel settings; installations configured for different regional list separators may display a different separator.

Excel stores dates as serial numbers and displays them according to the cell’s number format. If the result appears as a number, select the result cell and choose Home > Number Format, then select Short Date or another date format. The underlying result is still a date serial that Excel can use in further date calculations.

Enter EDATE in a worksheet

In Excel for Microsoft 365 on Windows, select the cell where the answer should appear, type the function with the appropriate cell references, and press Enter. You can also start typing =EDATE( and select cells as you build the arguments. If Excel does not recognize a date in the starting cell, check whether that entry is stored as text rather than as a date value.

For a safer way to construct a date inside a formula, use the DATE function as the starting date. With A2 containing the year 2025, B2 the month 1, and C2 the day 15, enter =EDATE(DATE(A2,B2,C2),2) in D2. It returns March 15, 2025. This approach avoids ambiguity between date-entry conventions such as month/day/year and day/month/year.

On Excel for Mac, the function and basic entry process are the same. Excel for the web also supports EDATE. The most noticeable differences are interface details and regional settings, which can affect menu labels or the separator Excel expects between arguments.

Examples for common date calculations

  • Move a date forward: With A2 holding June 10, 2025, and B2 holding 3, enter =EDATE(A2,B2) in C2. It returns September 10, 2025.
  • Move a date backward: With A2 holding June 10, 2025, and B2 holding -2, enter =EDATE(A2,B2) in C2. It returns April 10, 2025.
  • Return the same date: With a valid date in A2 and 0 in B2, =EDATE(A2,B2) in C2 returns the date in A2.
  • Calculate a date 12 months later: With a starting date in A2 and 12 in B2, =EDATE(A2,B2) in C2 returns the corresponding date one year later, subject to the end-of-month adjustment described below.

In each example, the calculation uses calendar months rather than a fixed number of days. That distinction is useful for recurring billing periods, probation or review dates, subscription intervals, and other schedules defined by months. For money-related schedules, treat these examples as spreadsheet mechanics only: verify actual dates and obligations against the applicable agreement or a qualified professional.

What happens at the end of a month

If the day number from the starting date does not exist in the destination month, EDATE returns the last valid day of that destination month. For example, January 31 plus one month has no February 31, so Excel returns February 28 in a non-leap year or February 29 in a leap year. With A2 containing January 31, 2025, and B2 containing 1, =EDATE(A2,B2) in C2 returns February 28, 2025.

EDATE does not always preserve an end-of-month pattern in later calculations. If A2 contains February 28, 2025, and B2 contains 1, =EDATE(A2,B2) in C2 returns March 28, 2025, not March 31. EDATE uses the day number of its starting date when that day exists in the destination month; it does not interpret every month-end date as a request for the next month’s final day.

That difference can matter when building a sequence. If a schedule must always land on the last calendar day of each month, use EOMONTH instead. With January 31, 2025, in A2 and 1 in B2, =EOMONTH(A2,B2) in C2 returns February 28, 2025. EOMONTH explicitly returns the last day of the month a specified number of months away.

Using EDATE for recurring schedules

A common setup puts the first date in one cell and a month interval in another, then copies the formula down. For example, with the first schedule date in A2 and the interval 1 in B2, enter =EDATE(A2,B2) in A3 to calculate the next monthly date. To continue the schedule, place the same pattern in the next row using the previous result as the starting date and fill down. Each date is calculated from the prior row, so month-end adjustments can affect later dates.

If you need each scheduled date to stay anchored to the original starting day, calculate each row from the original date and a changing month count instead. With the original date in A2 and the number of months for a given row in B3, enter =EDATE($A$2,B3) in C3. For example, B3 equal to 1 returns the first monthly date after A2, while B4 equal to 2 in the next row returns the date two months after A2. The dollar signs keep the starting-date reference fixed when you copy the formula down.

For schedules that require the last day of every month, use EOMONTH with a month count that increases by one for each successive row. Choose between the functions based on the rule you need: “same day number if possible” points to EDATE, while “month’s final day” points to EOMONTH.

EDATE compared with adding days or using EOMONTH

Adding 30 days is not equivalent to adding one month. Some months have 28 or 29 days and others have 30 or 31, so a fixed-day calculation can drift from a monthly calendar schedule. EDATE is appropriate when the interval is measured in months. Adding a number of days is appropriate when the requirement specifies an exact number of elapsed days.

EDATE and EOMONTH are related but answer different questions. EDATE aims for the starting date’s day number in the destination month, adjusting to that month’s last day if necessary. EOMONTH returns the final calendar day of the destination month, regardless of the starting date’s day. Choosing the wrong one can shift a payment plan, report, or reminder to a different day than intended.

Neither function calculates business days or automatically skips weekends and holidays. If a date must move to a working day, that is a separate scheduling rule and may require a business-day function or additional logic. Be clear about whether the desired result is a calendar-month date, a month-end date, or a working-day date before selecting a formula.

Common EDATE problems and how to fix them

  • The answer is a number: The result cell may be formatted as General or Number. Apply a date number format; do not change the formula just because Excel displays its serial value.
  • The formula returns an error: Check that the starting-date cell contains a valid date and the month argument is numeric. A date-looking text entry can fail to behave like a date, especially when its format is ambiguous.
  • The result is one month earlier or later than expected: Confirm the sign and value of the month argument. A negative number moves backward; a positive number moves forward.
  • A schedule stops landing on the desired day: Review whether each row references the preceding result or the original start date. Also decide whether you need EDATE or the month-end behavior of EOMONTH.
  • The formula is rejected as typed: Check the argument separator used by your Excel regional settings. Some configurations use semicolons instead of commas. Use the separator Excel accepts, and verify that each opening parenthesis has a matching closing parenthesis.

Excel’s date system also has limits, and workbooks can use different date systems. In ordinary current workbooks, dates should be entered and stored as valid Excel dates; imported files or dates outside the supported range may need special handling. When comparing dates between workbooks, confirm that both values are genuine dates and that the displayed result matches the intended calendar date.

Frequently Asked Questions

What does EDATE stand for in Excel?
EDATE is the name of Excel’s function for calculating a date a specified number of months before or after a starting date. It is commonly understood as relating to an end date, but the practical meaning is the month-offset date the function returns.

Does EDATE add 30 days?
No. EDATE moves by calendar months, whose lengths vary. Use a day-based calculation when you need an exact number of elapsed days; use EDATE when you need a date a certain number of months away.

How do I subtract months with EDATE?
Use a negative number for the months argument. For example, with a date in A2 and -3 in B2, =EDATE(A2,B2) returns a date three calendar months before A2, with the usual adjustment if the destination month is shorter.

Why does EDATE return February 28 instead of March 3?
It is calculating a month offset, not adding a fixed number of days. When the target month lacks the starting day number, Excel returns that target month’s last day. A calculation based on adding days would answer a different question.

How can I get the last day of the next month?
Use EOMONTH rather than EDATE. EOMONTH is designed to return the last calendar day of a month at a specified offset, while EDATE returns a corresponding day number when possible.

Why is my EDATE result showing as a serial number?
Excel stores dates as serial values, and the result cell may not be formatted as a date. Apply Short Date or another date number format to display it as a calendar date.

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.