How to Add Years to Date in Google Sheets

To add years to a date in Google Sheets, you can use the EDATE function. The EDATE function calculates a new date after adding a specific number of months to a given date. To add years, you'll need to convert the number of years to months.

Here's a step-by-step guide on how to add years to a date in Google Sheets:

1. Open your Google Sheet or create a new one.
2. Click on a cell where you want to display the new date.
3. Type the following formula: =EDATE(start_date, years_to_add * 12)
   • Replace start_date with the cell containing the date you want to add years to, or enter a date in quotes (e.g., "2021-01-01").
   • Replace years_to_add with the number of years you want to add or the cell containing that number.

For example, if you want to add 3 years to the date in cell A1, your formula would look like this: =EDATE(A1, 3 * 12)

Once you press Enter, the cell will display the new date after adding the specified number of years.

Example

Let's say you have the following date in cell A1: 2021-01-01

And you want to add 5 years to it. Follow these steps:

1. Click on cell B1 or any other cell where you want to display the new date.
2. Type the formula: =EDATE(A1, 5 * 12)
3. Press Enter.

Now, cell B1 will display the new date: 2026-01-01