Table of Contents
Google Sheets offers a convenient way to add and subtract years from a given date. You can use the DATE function and simple mathematical calculations to add or subtract a given number of years from a date in Google Sheets. The DATE function takes three inputs, which are the year, month, and day of the date that you want to calculate. To add or subtract years, simply add or subtract the given number of years to the year input of the DATE function. This will allow you to quickly and easily add or subtract years from a date in Google Sheets.
You can use the following basic formulas to add and subtract years from a date in Google Sheets:
Formula 1: Add Years to Date
=EDATE(A1, 12*(3))
This particular formula adds 3 years to the date in cell A1.
Formula 2: Subtract Years from Date
=EDATE(A1, -12*(1))
This particular formula subtracts 1 year from the date in cell A1.
The following examples show how to use each formula in practice with the following dataset in Google Sheets:
Example 1: Add Years to Date in Google Sheets
We can type the following formula into cell C2 to add 3 years to the date in cell A2:
=EDATE(A2, 12*(3))
We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the date in column A with exactly 3 years added to it.
Feel free to change the 3 in the formula to any value you’d like to add a different number of years to the original date.
Example 2: Subtract Years from Date in Google Sheets
=EDATE(A2, -12*(1))
We can then drag and fill this formula down to each remaining cell in column C:
Column C now displays the date in column A with 1 year subtracted from it.
Feel free to change the 1 in the formula to any value you’d like to subtract a different number of years from the original date.