EDATE in Excel: How to Add Years to a Date Correctly

Formulas & functions · Updated November 18, 2026

Excel’s EDATE function adds months, not years. To add a whole number of years to a date in A2, with the number of years in B2, use =EDATE(A2,12*B2); for example, a date of 15 June 2024 and a value of 3 returns 15 June 2027.

What EDATE Does in Excel

EDATE moves a date forward or backward by a specified number of calendar months. Its two inputs are a starting date and a month count. A positive month count moves forward; a negative count moves backward. Because a year is 12 months for this calculation, multiplying a years value by 12 is the straightforward way to use EDATE for yearly dates.

This makes the function useful for recurring dates such as annual reviews, contract anniversaries, subscription renewals, and payment schedules. It calculates a calendar date rather than adding a fixed number of days. A year can have 365 or 366 days, so adding 365 days is not a reliable substitute for moving forward one calendar year.

In Microsoft 365 for Windows, EDATE is available as a normal worksheet function; you do not need to enable an add-in. It returns an Excel date serial number, which Excel can display as a date when the result cell has a date format.

The Formula for Adding Years

Suppose A2 contains the starting date and B2 contains a whole-number year adjustment. Enter this formula in C2:

With the start date in A2 and the number of years in B2, use =EDATE(A2,12*B2). For example, if A2 is 15 June 2024 and B2 is 3, the result is 15 June 2027.

The multiplication converts the year count into months: 3 years × 12 months equals 36 months. The same formula handles earlier dates. If B2 is -2, Excel moves the date back by 24 months. If B2 is 0, the result is the original date.

You can also put the year count directly into a formula when it is a fixed value. With the starting date in A2 and a fixed three-year term, use =EDATE(A2,36). A cell reference is usually easier to maintain when the year count may change or when you want to fill the formula down a list.

Examples With Different Year Counts

With a starting date of 10 October 2025 in A2 and 5 in B2, =EDATE(A2,12*B2) returns 10 October 2030. With the same starting date and -2 in B2, it returns 10 October 2023. These results follow the calendar, rather than estimating a year as a fixed number of days.

For a list of records, put each original date in column A and its year adjustment in column B. Enter the formula in C2, then use the fill handle to copy it down. Each row will refer to its own date and year count. This is convenient for calculating different renewal dates in one table without rewriting the formula for every record.

If the year count is not a whole number, the formula still converts it to months. For instance, 1.5 years becomes 18 months. EDATE uses a whole-number month count and truncates any fractional part of that month argument, so a value that produces a partial month may not give the date someone expects. For predictable annual dates, use whole years; for a deliberately month-based interval, enter the intended number of months directly.

Month-End Dates and Leap Years

A common question is what happens when the starting day does not exist in the target month. EDATE returns the last valid day of that month. For example, adding one month to 31 January 2025 returns 28 February 2025, not a date in March. Adding one month to 31 January 2024 returns 29 February 2024, because 2024 is a leap year.

This matters when the date is an anniversary. A starting date of 29 February 2024 moved forward one year with EDATE lands on 28 February 2025, because February 2025 has no 29th day. Moving the original date forward four years lands on 29 February 2028. If a policy or agreement specifies a different rule for leap-day anniversaries, such as observing them on 1 March, the spreadsheet formula should reflect that rule rather than assuming EDATE’s behavior is the required one.

Calculate each future date from the original starting date when you want to avoid accidental drift. With 31 January 2025 in A2, this formula calculates two months from that original date:

With the original date in A2 and a two-month offset, use =EDATE(A2,2); the result is 31 March 2025. By contrast, if you calculate February from January and then calculate the next month from that February result, the intermediate date is 28 February, and moving one month from it returns 28 March. The second calculation has inherited the adjusted day. This distinction is important for schedules that repeatedly calculate the next due date.

Entering Dates and Formatting Results

EDATE needs a real Excel date value as its starting date. Dates typed in a cell are usually recognized automatically, but interpretation can depend on regional settings: a value such as 04/05/2025 can mean 4 May or April 5. Use an unambiguous date entry or check the cell’s displayed value before relying on the result. Imported data can also contain dates stored as text, which may not behave like normal date values.

To format the result in Excel for Microsoft 365 on Windows, select the result cells and choose Home > Number Format, then select Short Date or Long Date. You can also select the cells and press Ctrl+1 to open Format Cells and choose a date format. In Excel for Mac, the Home tab has a Number Format control as well; Command+1 opens the Format Cells dialog.

If the result appears as a number such as 45823, the calculation may be correct: Excel stores dates as serial numbers and the cell may simply be using General or Number formatting. Apply a date format to display it as a calendar date. If it shows an error instead, first check that the starting value is a valid date and that the formula references the intended cells.

EDATE Compared With DATE and EOMONTH

EDATE is generally the clearest choice when the task is to move a date by a number of months or years while retaining the day where possible. The DATE function can also build a date from year, month, and day components, but it handles an invalid day differently: it rolls the overflow into the following month. For example, constructing 29 February in a non-leap year with DATE can produce 1 March rather than EDATE’s 28 February.

With the original date in A2 and the number of years in B2, =DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2)) constructs a date using the original month and day. It can be useful when that rollover behavior is specifically wanted, but it is not always interchangeable with EDATE. Check the expected rule for dates such as 29 February before choosing between them.

EOMONTH is intended for calculations that should land on the last day of a month. With the starting date in A2 and the number of years in B2, =EOMONTH(A2,12*B2) returns the last day of the month that is the specified number of years away. If A2 is 15 June 2024 and B2 is 1, it returns 30 June 2025, whereas EDATE returns 15 June 2025. Choose EOMONTH for month-end schedules, not for ordinary same-day anniversaries.

Common Problems and How to Fix Them

  • The result is a number: Format the cell as a date. Excel stores dates as serial values, so this is usually a display issue rather than a formula error.
  • The formula returns an error: Check that the starting cell contains a valid Excel date and that the month calculation produces a usable number. Text that only looks like a date may need to be converted first.
  • The date is one day or several months off: Check whether the original entry was interpreted using the wrong regional date order, and confirm that the formula references the intended row.
  • The formula is copied but every row uses the same date: Check for dollar signs that lock a reference, such as $A$2. Relative references such as A2 normally adjust when filled down.
  • The answer is February 28 instead of March 1: That is EDATE’s month-end adjustment for a date that does not exist in February. Confirm whether the intended rule is the last day of February or another anniversary convention.

In formulas, Excel for Windows normally uses commas between function arguments, as shown here. If a computer’s regional settings use semicolons as list separators, Excel may display or require semicolons instead. Use the separator Excel accepts in that installation; the calculation itself is unchanged.

When Adding Years Is the Right Calculation

Adding years with EDATE is appropriate when the goal is a calendar anniversary or a date a fixed number of months away. Examples include calculating a renewal date three years after a start date, or finding a review date one year after an event. It does not measure the exact number of elapsed days, workdays, or completed years between two dates.

For a complete-years age or service-length calculation, the question is different: you need to count how many anniversaries have passed by a given end date. A date obtained by adding years to a start date does not itself calculate that elapsed count. Likewise, if the schedule is based on business days or month ends, use a function designed for that calendar rule rather than treating every interval as an ordinary anniversary.

For formal deadlines, contract terms, or payment schedules, confirm the applicable date convention. A spreadsheet can apply a consistent arithmetic rule, but it cannot determine whether a particular organization treats a leap-day anniversary as 28 February, 1 March, or another date.

Frequently Asked Questions

Does EDATE add years or months?
EDATE adds months. Multiply the number of years by 12 to use it for years, as in =EDATE(A2,12*B2) when A2 contains the start date and B2 contains the year count.

How do I add one year to a date in Excel?
With the date in A2, enter =EDATE(A2,12). Format the result cell as a date if Excel displays a serial number.

What does EDATE return for February 29?
If the target year is not a leap year, EDATE returns 28 February. If the target year is a leap year and the month offset lands in February, it can return 29 February.

Why does EDATE show a number instead of a date?
Excel stores dates as numbers. Select the result cell and apply a date format from Home > Number Format, or open Format Cells and choose a date format.

Can EDATE calculate dates in the past?
Yes. Use a negative month count. With a starting date in A2 and a two-year move backward, =EDATE(A2,-24) returns the corresponding date two calendar years earlier, subject to month-end adjustment.

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.