How to Add Years to a Date in Excel (3 Easy Ways)

Consider the following dataset. We’ll add years to the joining dates.

3 Ways to Add Years to a Date in Excel

Method 1 – Using Simple Arithmetic to Add Years to a Date in Excel

We modified the dataset to contain the number of years to add in cell C4 and moved the rest down.
Select the D7 cell.
Insert the following formula.

=C7+($C$4*365)

This will add the entered number of years (In my case, 2 years) to the existing date by adding 365 days times the value of C4.

Use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.

Syntax of the EDATE Function

=EDATE (start_date, months)

=EDATE(C7,($C$4*12))

Use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.

Syntax of the DATE Function

=DATE (year, month, day)

=DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7))

Formula Breakdown

DAY(C7): This argument in the DATE function shows the number of days for the date and the value is 1.
MONTH(C7): This argument in the DATE function finds the number of months for the date and it returns the value 1.
YEAR(C7)+$C$4: This argument in the DATE function shows the number of years for the date and it returns the value by adding the value of C4 cell (5) as 2023.
=DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7)): This whole function finally shows the result as 1/1/2023.