Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

Sometimes, it’s essential to include dates in an Excel dataset for ease of use. You may need to add certain years to the date. There are several functions to do this operation. Also, you can follow a simple arithmetic formula to add years to the date. You can use any formula of your choice. In this article, we are going to show you some methods to add 2 years to a date in Excel. Let’s get started.


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


3 Methods to Add 2/3 Years to a Date in Excel

You have to make a dataset first to add years to the date. We have taken a dataset of Students’ Admission Dates. Now, we want to append 2 years to these dates.

Dataset

Not to mention, we have used the Microsoft 365 version. You may use any other version at your convenience.


1. Utilizing Arithmetic Formula

A year consists of 365 days we all know that. If you add 2*365 days to the date, then it will show exactly 730 days after the following dates. Follow the steps.

📌 Steps:

  • Firstly, go to the D5 cell and enter the following formula.
=C5+(2*365)

It adds 2 years to the existing date.

Arithmetic Formula to add 2 Years to a Date in excel

  • Subsequently, press ENTER and drag down the Fill Handle tool for the other cells.

Fill Handle

You will eventually get the result shown in the image below.

But there is a significant issue with this method. You know that a leap year consists of 366 days. So, when you add 365 days, it shows you the day before the existing day if there is a leap year. In such a situation, it is better to utilize the following two methods.

Read More: How to Add Days to Date Using Excel Formula (5 Easy Ways)


2. Using the EDATE Function

The EDATE function provides a date according to the months number given in the argument. The entered number of months has been added to the existing value and returned as a result. Go through the following steps for better visualization.

📌 Steps:

  • Initially, move to cell D5 and insert the formula.
=EDATE(C5,(2*12))

It takes 24 months, as we entered the end_date argument as (2*12) with the start_date of the C5 cell.

Using the EDATE Function to add 2 years to a date in Excel

Finally, you get the result shown in the above image after pressing ENTER.

Read More: Excel Formula to Count Days from Date (5 Easy Methods)


Similar Readings


3. Applying the Nested DATE Function

You can use the nested DATE function to add 2 years to the date. In that case, you need to combine the YEAR, MONTH, and DAY functions to show the date. However, when we insert the YEAR function, we add two years because we want to. Follow the below steps.

📌 Steps:

  • Firstly, go to cell D5 and enter the formula.
=DATE(YEAR(C5)+2,MONTH(C5),DAY(C5))

Formula Explanation:

  • DAY(C5) syntax takes the day number of cell C5.
  • MONTH(C5) syntax provides the month number of cell C5.
  • YEAR(C5)+2 syntax adds 2 years with the existing year in cell C5.
  • Finally, the DATE(YEAR(C5)+2, MONTH(C5), DAY(C5)) syntax returns the date where the years are changed with 2 years.

Eventually, press ENTER, and drag it down.

Using the Nested DATE Function to add 2years to a date in Excel

Finally, you get the outcome depicted in the image below.

Similarly, you can also add 3 years to the existing date. Here, we enter the end_date argument (3*12). The procedure is identical to Method 2. See the below image. Here, you can see 3 years have been added to the existing dates.

The formula we used here,

=EDATE(C5,(3*12))

Adding 3 years to a date in Excel

Read More: How to Apply Excel Formula to Count Days from Date to Today


How to Add Days to a Date in Excel

You can add days to your date using Method 3. The only extra task is that you have to add the number of days with the DAY function. We entered the following formula.

=DATE(YEAR(C5),MONTH(C5),DAY(C5)+15)

The basic difference is that the YEAR function here will remain unchanged, but we have added 15 with the DAY function, which will add 15 days to the existing value. See the image to get a proper idea.

How to Add Days to a Date in Excel 

Read More: How to Add 7 Days to a Date in Excel (3 Methods)


How to Add Months to a Date in Excel

Yet again, we follow the same formula in Method 3. But you have to add the number of months with the MONTH function that you want to add. So, the formula for the D5 will be-

=DATE(YEAR(C5),MONTH(C5)+6,DAY(C5))

Here, we enter 6 with the MONTH function, which will add 6 months to the existing value. Look at the below image and observe the results carefully.

How to Add Months to a Date in Excel 

Read More: How to Add Months to a Date in Excel (2 Ways)


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it yourself.

Practice Section


Conclusion

That’s all about today’s session. And these are some easy methods to add 2 years to a date in Excel. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Visit our website, Exceldemy, a one-stop Excel solution provider, to find out about diverse kinds of Excel methods. Thanks for your patience in reading this article.


Related Articles

Fahim Shahriyar Dipto

Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

2 Comments
  1. Mr. Fahim. This article is quite helpful to me. It will be more helpful if you can enlighten me to show the day in text of your given date column. Then i can find out which day it was on that specific date.
    Thanks in advance.

    • Reply
      Fahim Shahriyar Dipto Nov 23, 2022 at 10:32 AM

      Hello, Mrs. Thomas. Thanks for your feedback. You can easily show the day in the text by using the TEXT function. Follow the steps for better visualization.
      Firstly, go to cell E5 and insert the method.
      =TEXT(D5,"dddd")
      It will make the day in full form of the text.

      Then press ENTER and drag it down for other cells with the Fill Handle tool.

      Finally, you got your result.

      For displaying the month in text go to the cell F5 and write up the formula.
      =TEXT(D5,"mmmm")

      Drag down it and get the full result for the dates.

Leave a reply

ExcelDemy
Logo