Add or Subtract Years to a Date in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to add (or subtract) years to a date in Excel and Google Sheets. 

Add Years to Date Main

Add Years to a Date

The easiest way to add years to a date is with the EDATE Function. The EDATE Function adds a specified number of months to a date. By adding months in multiplies of 12 (12,24,36, etc.) you can add years to a date.

Add 1 Year to a Date

This example will add 1 year to a date:


Add 1 Year to Date

Add 5 Years to a Date

This example will add 5 years to a date:


Add 5 Years to Date

Subtract Years From a Date

To subtract years from a date, simply enter a negative number of months into the EDATE Function:


subtract 3 years

Add Years with DATE Function

Another way to add years to a date is with the YEAR, MONTH, DAY and DATE Functions:


Add Years with DATE

The DATE Function creates a date using a specified Year, Month, and Day. We populate the DATE function with the current date’s year, month + a number of months and day using the YEAR, MONTH, and DAY Functions.

Subtract Years with DATE Function

Of course the same logic applies with subtracting dates:


Subtract Years with DATE

Add Years – First Day of New Year

To add years to a date and return the first day of the calculated year, you can also use the DATE Function:


Add year First Day

Add / Subtract Years in Google Sheets

The above examples work exactly the same in Google Sheets as in Excel:

Add Years to Date Google sheet

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List