Table of Contents
You can use the following formulas to calculate the number of years between two dates in Google Sheets:
Formula 1: Calculate Full Years Between Two Dates
=INT(YEARFRAC(A2,B2))
Formula 2: Calculate Fractional Years Between Two Dates
YEARFRAC(A2,B2)
Both formulas assume that cell A2 contains the start date and cell B2 contains the end date.
The following examples show how to use each formula in practice with the following list of start and end dates in Google Sheets:
Let’s jump in!
Example 1: Calculate Full Years Between Two Dates
Suppose we would like to calculate the number of full years between each start and end date.
We can type the following formula into cell C2 to do so:
=INT(YEARFRAC(A2,B2))
We can then click and drag this formula down to each remaining cell in column C:
Column C displays the number of full years between the start and end date in each row.
For example:
- There are 16 full years between 1/4/2005 and 1/1/2022.
- There are 15 full years between 3/15/2007 and 3/15/2022.
- There are 14 full years between 4/14/2008 and 4/18/2022.
And so on.
Example 2: Calculate Fractional Years Between Two Dates
Suppose we would like to calculate the number of fractional years between each start and end date.
We can type the following formula into cell C2 to do so:
=YEARFRAC(A2,B2)
We can then click and drag this formula down to each remaining cell in column C:
Column C displays the number of fractional years between the start and end date in each row.
For example:
- There are 16.992 years between 1/4/2005 and 1/1/2022.
- There are 15 years between 3/15/2007 and 3/15/2022.
- There are 14.011 years between 4/14/2008 and 4/18/2022.
And so on.
Note: You can find the complete documentation for the YEARFRAC function in Google Sheets .