We have already learned how to add or subtract the month from the current 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
General Formula:
- You can use the below formula to add a number of years to a date in Excel.
=DATE(YEAR(date)+years,MONTH(date),DAY(date))
Syntax Explanations:
- DATE – The*DATE Function*combines three different values and returns them as a date.
- YEAR – The Excel YEAR function 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.
- DAY – This function will return the day of the date. Read more on the DAY function.
- 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**.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
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 **and Excel Formulas *!! **
Top comments (0)