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
Table of Contents
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
