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 here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Add & Subtract Years to Date in Google Sheets

How to Calculate Year Over Year Growth in Google Sheets

How to Calculate Day of the Year in Google Sheets