Table of Contents
To add years to a date in Excel, you can use the DATE function. This function allows you to specify the year, month, and day and will return the date in a specific format. To add years, simply enter the current date in the format of “YEAR/MONTH/DAY” into the DATE function and add the desired number of years to the year value. This will automatically calculate and return the new date with the added years. Additionally, you can also use the EDATE function to add a specific number of months to a date, which can be useful for calculating dates in the future. By using these functions, you can easily add years to a date in Excel without having to manually calculate the new date.
Add Years to Date in Excel (With Examples)
You can use the following basic syntax to add years to a date in Excel:
=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))
This particular formula adds 3 years to the date in cell A2.
To add a different number of years, simply change the 3 in the formula to a different number.
And to subtract a certain number of years from a date, simply use a negative number instead of a positive number in the formula.
The following example shows how to use this syntax in practice.
Example: Add Years to Date in Excel
Suppose we have the following list of dates in Excel:
We can type the following formula into cell B2 to add 3 years to the date in cell A2:
=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))We can then drag and fill this formula down to each remaining cell in column B:
Notice that each of the values in column B show the value of the date in column A plus three years.
To add a different number of years, simply change the 3 in the formula to a different number.
For example, we can use the following formula to instead add 10 years to each date:
=DATE(YEAR(A2)+10,MONTH(A2),DAY(A2))
Now each of the values in column B shows the value of the date in column A plus 10 years.
We can also use a negative value in the formula to subtract years.
For example, we can use the following formula to instead subtract 10 years to each date:
=DATE(YEAR(A2)-10,MONTH(A2),DAY(A2))
Now each of the values in column B shows the value of the date in column A minus 10 years.
Note: We wrap the DATE function around the formula to ensure that the result is shown in a date format instead of a numeric format.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I add years to a date in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-add-years-to-a-date-in-excel/
stats writer. "How can I add years to a date in Excel?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-add-years-to-a-date-in-excel/.
stats writer. "How can I add years to a date in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-add-years-to-a-date-in-excel/.
stats writer (2024) 'How can I add years to a date in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-add-years-to-a-date-in-excel/.
[1] stats writer, "How can I add years to a date in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I add years to a date in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.