Excel Formulas to Add or Subtract the Years to the Given Date!!
Tags: excelformula, excelformulas
Published: 2021-04-29 03:46:52

---
title: Excel Formulas to Add or Subtract the Years to the Given Date!!
published: true
date: 2021-04-28 15:17:20 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-or-subtract-the-years-to-the-given-date/
---

We have already learned how to **[add or subtract the month from the current date](https://geekexcel.com/excel-formulas-to-add-month-to-date/)**. Likewise, here we are going to learn the simple formula to **add or subtract the years from the given date in Excel.** Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Add years to date](https://geekexcel.com/wp-content/uploads/2021/04/Add-years-to-date.png)](https://geekexcel.com/excel-formulas-to-add-or-subtract-the-years-to-the-given-date/add-years-to-date/#main)<figcaption id="caption-attachment-34880">Add years to date</figcaption>

## General Formula:

- You can use the below formula to add a number of years to a date in Excel.

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(date)+years,[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(date),[DAY](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/)(date))**

## Syntax Explanations:

- **DATE** – The**[DATE Function](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)**combines three different values and returns them as a date.
- **YEAR** – The Excel **[YEAR function](https://geekexcel.com/how-to-use-year-function-in-excel-365/)** is used to extract the year from the given date and returns the year as a 4-digit number.
- **MONTH** – It helps to return the month of a date. Read more on the **[MONTH function](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)**.
- **DAY** – This function will return the day of the date. Read more on the **[DAY function](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/)**.
- **Date**  – It specifies the input dates.
- **Plus operator (+)** – This symbol is used to add the values.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- First, we will enter the input dates in **Column B**.
- Now we are going to add or subtract the number of years given in ** Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-38.png)<figcaption id="caption-attachment-34882">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-30.png)<figcaption id="caption-attachment-34881">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-39.png)<figcaption id="caption-attachment-34883">Result</figcaption>

## Conclusion:

So yeah guys this is how we can **add or subtract the years from the given date in Excel**. I hope you like this article. Please share your **query** below in the **comment** box. We will assist you. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Round Number Down to Nearest Multiple Value!!](https://geekexcel.com/excel-formulas-to-round-number-down-to-nearest-multiple-value/)**
- **[How to Protect All Cells with Formulas using Macros in Excel 365?](https://geekexcel.com/how-to-protect-all-cells-with-formulas-using-macros-in-excel-365/)**
- **[Excel Formulas to Add Decimal Hours to the Time ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-add-decimal-hours-to-the-time/)**