EDATE Function in Excel: Add Months to Dates

Formulas & functions · Updated November 22, 2026

In Excel, EDATE adds or subtracts a specified number of whole months from a date. With a starting date in A2 and a month offset in B2, enter =EDATE(A2,B2); a positive offset moves forward, while a negative one moves backward.

What the EDATE Function Does

EDATE is useful when a date must move by calendar months rather than by a fixed number of days. For example, adding one month to a date means moving to the corresponding date in the following month when that day exists. This is helpful for recurring appointments, subscription periods, review dates, and schedules that repeat monthly.

A month is not a fixed number of days: calendar months have 28, 29, 30, or 31 days. That is why adding 30 days is not the same as adding one month. EDATE accounts for the calendar and adjusts the result when the destination month does not contain the original day.

The function returns an Excel date value, not a sentence or a month name. Excel stores dates as serial numbers and displays them according to the cell’s number format. The result can therefore be used in date arithmetic, comparisons, sorting, and other formulas.

EDATE Syntax and Arguments

The function has two required arguments: EDATE(start_date, months). The first argument is the date from which to count, and the second is the number of months to move. Months can be positive, negative, or zero. If the months value is not a whole number, Excel truncates its fractional part; for instance, 1.9 is treated as 1.

The start date can refer to a cell containing a date, or it can be created with DATE. Using DATE is a reliable way to enter a date directly in a formula because it avoids ambiguity between regional date formats. For example, 4/5/2025 can be read differently in different locales, while DATE(2025,5,4) explicitly means May 4, 2025.

With no worksheet inputs, because the date and month offset are supplied directly, =EDATE(DATE(2025,5,4),2) returns July 4, 2025. The formula is useful for a one-off calculation, but cell references are generally easier to maintain in a larger worksheet.

Worked Examples: Moving Forward and Back

Suppose A2 contains January 15, 2025, and B2 contains 3. With the starting date in A2 and the number of months to add in B2, =EDATE(A2,B2) returns April 15, 2025. If B2 is changed to 0, the result remains January 15, 2025.

Negative month offsets work in the same way. With March 31, 2024 in A2 and -1 in B2, the formula =EDATE(A2,B2) returns February 29, 2024. The leap-year result follows the calendar; it is not an approximation based on a fixed number of days.

A useful way to check a result is to compare its month and year with the intended destination, then inspect the day. EDATE generally preserves the day number when possible, but it cannot return a date such as February 31. In that case, it uses the last valid day of the destination month.

Month-End Dates and Leap Years

Month-end adjustment is one of the most important details to understand. If a date falls on the 31st and the next month has only 30 days, the result is the 30th. If the destination is February, the result is February 28 in a common year or February 29 in a leap year. Similarly, moving from January 30 to February gives the last day of February.

With no input cells, using DATE to supply January 31, 2025, and a one-month offset, =EDATE(DATE(2025,1,31),1) returns February 28, 2025. This does not mean EDATE always finds the last day of a month. It only adjusts when the original day number does not exist in the target month.

Be aware of what happens when you build a schedule by referring to the previous result. If A2 is January 31, 2025, and B2 contains =EDATE(A2,1), B2 is February 28. If the next row uses B2 as its starting date, the following result is March 28, not March 31. Each calculation starts from the adjusted date in the previous row.

To preserve the original anchor day when filling a schedule down, keep the original date fixed. With A2 containing January 31, 2025 and the first schedule result in B2, enter =EDATE($A$2,ROWS($B$2:B2)) in B2 and copy it down. The first results are February 28, March 31, and April 30, 2025. The absolute reference keeps the anchor date in A2, while ROWS increases the month offset as the formula is copied.

How to Enter and Format an EDATE Result

In Excel for Microsoft 365 on Windows, select the result cell, type the formula, and press Enter. To fill the formula into neighboring cells, select the cell and drag its fill handle, or copy and paste it. If the source date and month offset are in columns A and B, a formula in C2 can be copied down to calculate results for each row.

If the result appears as a number such as 45687 rather than a readable date, the calculation may still be correct: the cell is likely formatted as General or Number. Select the result, then choose Home > Number Format and select a date format. For more control on Windows, press Ctrl+1 to open Format Cells and choose a date format. On a Mac, Command+1 opens the Format Cells dialog.

Changing the display format does not change the underlying date value. A cell shown as 15-Jan-2025 and the same value shown as 1/15/2025 can still be used in the same calculations. If you need a result displayed as text for a report, that is a separate formatting task; keeping dates as date values is usually better for later calculations.

Building Monthly Schedules and Deadlines

EDATE can generate dates for a monthly billing cycle, a recurring inspection, or a review interval. Put the first date in one cell and calculate each future date from that fixed starting point when you want the original day of the month to guide the schedule. If the intended policy is instead to continue from each adjusted date, use the previous row as the next starting point. These approaches can produce different dates after a short month, so choose based on the schedule’s rules.

For a schedule that must always end on the last day of each month, EOMONTH may be a better fit. With A2 containing January 15, 2025 and B2 containing 1, the formula =EOMONTH(A2,B2) returns February 28, 2025. EOMONTH returns the final calendar day of the target month regardless of the starting day, whereas EDATE tries to preserve the starting day where possible.

For example, a monthly payment date on the 15th is a natural EDATE use case. A report that must be dated on each month’s final day is a natural EOMONTH use case. For real contracts, billing arrangements, or other consequential schedules, verify that the formula’s date rule matches the written terms; this is a spreadsheet explanation, not financial or legal advice.

Common Problems and How to Fix Them

  • The result is a serial number: Apply a date number format. The underlying calculation can be valid even when the display is not what you expected.
  • Excel returns #VALUE!: Check whether the start-date cell contains a real Excel date or a value Excel can interpret as one. Text that merely looks like a date may be stored as text. DATE can help create an unambiguous date from year, month, and day values.
  • The result is earlier or later than expected: Check the sign and value of the months argument. A negative number moves backward, and a fractional month value is truncated rather than treated as a fraction of a month.
  • The day changes after February: Check whether each row refers to the previous result. A date adjusted to February 28 can lead to March 28 in a chained schedule. Refer to the original date if you need to restore the original day when later months allow it.
  • A date is outside Excel’s supported range: Excel cannot represent every theoretical date. If a calculation moves beyond its supported date range, the formula cannot return a usable date. Review the source date and offset.

When typing dates directly into cells, avoid assuming that a slash-separated value will mean the same thing on every computer. Regional settings affect how date text is interpreted. A real date entered using the date picker, or a date created with DATE(year,month,day), is less likely to be misunderstood.

EDATE Compared with EOMONTH and Day Arithmetic

EDATE and EOMONTH both move by calendar months, but they answer different questions. EDATE aims for the same day number in another month and adjusts when that day does not exist. EOMONTH returns the final day of the destination month. Use EDATE for a date intended to recur around the same day number; use EOMONTH when the month’s endpoint is the requirement.

Adding a number to a date is day arithmetic. With A2 containing January 15, 2025, the formula =A2+30 returns February 14, 2025. That is 30 days later, not one calendar month later. With the same value in A2, =EDATE(A2,1) returns February 15, 2025. The difference is small in this example, but it can matter in recurring schedules and across months of different lengths.

Frequently Asked Questions

Does EDATE include the starting date as month zero?
Yes. A months argument of 0 returns the starting date. A value of 1 moves one calendar month forward, and -1 moves one calendar month backward.

Why does EDATE return February 28 instead of March 2?
EDATE advances by calendar months, not by a fixed number of days. When the target month does not contain the starting day number, it returns that month’s last day rather than carrying the extra days into the following month.

Can EDATE calculate a date in the past?
Yes. Use a negative number for months. For example, an offset of -6 moves the date six calendar months earlier, subject to the same month-end adjustment rules.

What is the difference between EDATE and EOMONTH?
EDATE preserves the original day number when that day exists in the destination month. EOMONTH always returns the final day of the destination month. Choose based on whether the schedule follows a particular day or month-end.

Why does my EDATE result show as a number?
Excel stores dates as serial values. If the result cell uses General or Number formatting, it may display that serial instead of a calendar date. Apply a date format to change how the value appears.

Is EDATE available in Excel for the web and on Mac?
EDATE is available in current Microsoft Excel, including Microsoft 365 for Windows, Mac, and the web. The formula syntax is the same; steps for formatting and keyboard shortcuts can differ by platform.

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.