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

In MS Excel, working with date-type values is a necessary requirement. It involves tasks like adding days, months, or years to existing dates. In this article, we will demonstrate to you to add years to a date in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


3 Easy Ways to Add Years to a Date in Excel

Here, we will show you to add years to a date in Excel by using a simple arithmetic operation, the EDATE function, and combining multiple functions such as the DATE function with the YEAR function, the MONTH function, and the DAY function. Let’s suppose we have a sample data set.

3 Ways to Add Years to a Date in Excel


1. Using Simple Arithmetic Operation to Add Years to a Date in Excel

In this section, we will apply simple arithmetic operations to add years to a date in Excel. To learn better, you can follow the steps below.

Step 1:

  • Firstly, select the D7 cell.
  • Then, write down the following formula.

=C7+($C$4*365)

  • Here, it will add the entered number of years (In my case, 2 years) to the existing date by adding the number of days to it.
  • After that, hit ENTER.

Using Simple Arithmetic Operation to Add Years to a Date in Excel

Step 2:

  • So, you will see the result of 2 years added with the first person joining date.
  • Then, use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.

Step 3:

  • Finally, the given image displays all the 2 years added joining date in the D column.


2. Utilizing EDATE Function to Add Years to a Date

The EDATE function adds the entered number of months to the entered data and returns the value.

Syntax of the EDATE Function

=EDATE (start_date, months)

Arguments of the EDATE Function

Start_date: This argument represents the existing date-type value.

Months: This argument signifies the number of months to be added.

Step 1:

  • Firstly, select the D7 cell.
  • Then, write down the following formula below here.

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

  • Here, it will add the entered years (In my case, 5 years) to the existing date by creating a new date with the given values.
  • After that, hit ENTER.

Utilizing EDATE Function to Add Years to a Date in Excel

Step 2:

  • Then, you will see the result of 5 years added with the first person joining date.
  • After that, use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.

Step 3:

  • Lastly, you will see all the results of 5 years added with the joining date in the D column here.


3. Combining Multiple Functions to Add Years to a Date in Excel

There are a number of functions in Excel for altering date values, but the DATE function is by far the most versatile and straightforward. It constructs a valid date from the individual year, month, and day values.

Syntax of the DATE Function

=DATE (year, month, day)

Arguments of the DATE Function

Year: This argument represents the number of years for the date.

Month: This argument indicates the number of months for the date.

Day: This argument signifies the number of days for the date.

Step 1:

  • Firstly, choose the D7 cell.
  • Secondly, type the following formula below here.

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

  • Here, it will add the entered years (In my case, 5 years) to the existing date by adding the number of years.
  • Then, press ENTER.

Combining Multiple Functions to Add Years to a Date in Excel

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) is 2023.
  • =DATE(YEAR(C7)+$C$4,MONTH(C7),DAY(C7)): This whole function finally shows the result as 1/1/2023.

Step 2:

  • Therefore, you will see the result of 5 years added with the first person joining date.
  • Besides, use the Fill Handle tool and drag it down from the D7 cell to the D11 cell.

Step 3:

  • Lastly, in the D column, you can see the totals for the five years summed together with the joining date.


Conclusion

In this article, we’ve covered 3 ways to add years to a date in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

Chinmoy Mondol

Chinmoy Mondol

Greetings! Thank you for visiting my profile. I am Chinmoy Mondol. I am a conscientious, tech enthusiast individual with a voracious appetite for knowledge and a desire to learn more. I graduated from American International University-Bangladesh with a Bachelor's Degree in Computer Science and Engineering. I enjoy using my skills to contribute to the exciting technological advances that happen every day. Constant advancement and personal development are my guiding principles.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo