How to calculate years between two dates in Google Sheets and Excel

Sometimes you may need to know how many years are there between two dates. Counting the years with the manual methods may be tiresome and time confusing. Therefore, you may need an automatic way to assist you in calculating the years between a given date. Excel and Google Sheets tool got you covered!

To calculate Years between dates in Google Sheets

Methods that are used:

Using the YEARFRAC function

Steps:

1. On the first column, create the Start date column and enter the first dates.

2. On the second column, enter the End date. Then, locate an empty column that will contain the differences.

3. On the result column, type this formula =YEARFRAC(

4. Select the cell index of the Start date, enter a comma, and then enter the cell index of the End dates. That is, =YEARFRAC(Start-date,End_date).


Using the DAYS function.

Steps:

1. On the first column, create the Start date column and enter the first dates.

2. On the second column, enter the End date. Then, locate an empty column that will contain the differences.

3. On the result column, type this formula =DAYS(

4. Select the cell index of the End dates, enter a comma, and then enter the cell index of the Start date. That is, =DAYS( End_dates, Start_date)/366


Note: Let’s assume every year has 366 days

5. Press the Enter button.

Using the DATEDIF function

Steps:

1. On the first column, create the Start date column and enter the first dates.

2. On the second column, enter the End date. Then, locate an empty column that will contain the differences.

3. On the result column, type this formula =DATEDIF(

4. Select the cell index of the Start date, enter a comma, and then enter the cell index of the End dates. That is, =DATEDIF(Start_date, End_dates, “Y”)


Using the Minus Function

Steps:

1. On the first column, create the Start date column and enter the first dates.

2. On the second column, enter the End date. Then, locate an empty column that will contain the differences.

3. On the result column, type this formula =MINUS(

4. Select the cell index of the End dates, enter a comma, and then enter the cell index of the Start date. That is, =Minus( End_dates, Start_date)/366


To calculate Years between dates in Excel

Methods used:

Using DATEDIF function

Steps:

1. On the first column, create the Start date column and enter the first dates.

2. On the second column, enter the End date. Then, locate an empty column that will contain the differences.

3. On the result column, type this formula =DATEDIF(

4. Select the cell index of the Start date, enter a comma, and then enter the cell index of the End dates. That is, =DATEDIF(Start_date, End_dates, “Y”)


Using NETWORKDAYS function

Steps

1. On the first column, create the Start date column and enter the first dates.

2. On the second column, enter the End date. Then, locate an empty column that will contain the differences.

3. On the result column, type this formula =NETWORKDAYS(

4. Select the cell index of the Start date, enter a comma, and then enter the cell index of the End dates. That is, =NETWORKDAYS( start_date, end_date, holidays)/366

Leave a Comment