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.

## 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. 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. • Subsequently, press ENTER and drag down the Fill Handle tool for the other cells. 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.

### 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. Finally, you get the result shown in the above image after pressing ENTER.

### 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. 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)) 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 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. ## Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it yourself. ## Related Articles #### 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.

1. Reply Birdie Thomas Nov 22, 2022 at 5:01 PM

• 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.  `=TEXT(D5,"mmmm")`   