Function Problems

How to Automatically Add Three Years to a Date in Excel

Khadija Khan Sep 28, 2026 869 views

Question details

Calculate an expiration date that is exactly three years after a specified start date using a formula.

How to Automatically Add Three Years to a Date in Excel

Product: Excel
Device & OS: not provided
Scenario: Tracking certificate expiration dates, contract renewals, or warranty periods that last for exactly three years.
Observed behavior: The user needs a fast, automated way to output a date three years in the future in a separate column without calculating it manually.

Before you start

Ensure that your original certificate or start dates are formatted as true Date values in Excel, rather than plain text, so the formulas can recognize and calculate them correctly.

Solution 1Recommended

Use the EDATE Function (Recommended)

The EDATE function is the fastest and most reliable way to add a specific number of months to a date, automatically handling varying month lengths and leap years.

The EDATE function requires two arguments: the start date and the number of months to add. Since there are 12 months in a year, you will use 36 months to represent exactly three years.

Select the target cell

Click on the cell where you want the new expiration date to appear (for example, cell B2).

Enter the EDATE formula

Type the formula =EDATE(A2, 36) into the cell, assuming your original date is in cell A2.

Apply the formula

Press the Enter key on your keyboard to calculate the result.

Format the result as a date

If the result shows up as a 5-digit number, right-click the cell, select 'Format Cells', choose the 'Date' category, and pick your preferred date format.

Copy the formula down

Click the small square at the bottom-right corner of cell B2 and drag it down the column to apply the formula to the rest of your list.

Handling Past Dates: You can also use this formula to find a date three years in the past by using a negative number, like =EDATE(A2, -36).

Solution 2

Use the DATE, YEAR, MONTH, and DAY Functions

This method breaks the date down into its individual components, making it highly customizable if you need to add years, months, and days simultaneously.

Easy Date Calculations in WPS

Calculate Expiration Dates Easily with WPS Spreadsheet

WPS Spreadsheet fully supports all standard date functions like EDATE and DATE. It offers a powerful, user-friendly, and free environment to track certificates, schedules, and renewals seamlessly.

1. Open your document: Launch WPS Office and open your spreadsheet containing the start dates.
2. Insert the formula: Click the cell next to your start date and type =EDATE(A2, 36).
3. Format cell: Right-click the cell, select Format Cells, and apply your preferred Date format.
4. Drag to fill: Double-click the fill handle in the bottom-right corner of the cell to apply the calculation to your entire column instantly.

100% compatible with Microsoft Excel formulas and .xlsx file formatsBuilt-in function wizard to help you build complex date formulas easilyFree to download with a lightweight installation packageIntuitive interface that requires zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why is my formula returning a 5-digit number instead of a date?

Excel and WPS Spreadsheet store dates as sequential serial numbers for calculation purposes. To fix this, simply select the cell, go to the Home tab, click the Number Format dropdown, and choose 'Short Date' or 'Long Date'.

How do I add exact days instead of years?

If you need to add an exact number of days rather than calendar years, you do not need a special function. Simply use basic addition. For example, to add 30 days to cell A2, type =A2+30.

Does the EDATE function account for leap years?

Yes, the EDATE function automatically adjusts for varying month lengths and leap years. If you add months to February 29th, it will accurately land on February 28th of a non-leap year.

Excel & Data Problems