Often you may want to calculate average employee tenure at some company in Excel.

Fortunately this is easy to do and the following step-by-step example shows how to do so.

**Step 1: Enter the Data**

First, let’s enter the following dataset that shows the start and end date for various employees at some company:

**Step 2: Calculate Tenure of Each Employee**

Next, we can type the following formula into cell **D2** to calculate the tenure of the first employee:

=YEARFRAC(B2, C2)

We can then click and drag this formula down to each remaining cell in column D:

Column D now shows the tenure (in decimal years) of each individual employee.

**Note**: The **YEARFRAC** function returns the number of decimal years between a specific start and end date.

**Step 3: Calculate Average Tenure**

Lastly, we can type the following formula into cell **D11** to calculate the average employee tenure:

=AVERAGE(D2:D11)

The following screenshot shows how to use this formula in practice:

The average tenure of employees at this company is about **4.25 years**.

If you would like to display this number in terms of years and months, you can type the following formula into cell **E11**:

=INT(D11) & " years, " & INT((D11-INT(D11))*12) & " months"

The following screenshot shows how to use this formula in practice:

The average tenure of employees at this company is about **4 years and 3 months**.

**Additional Resources**

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

How to Calculate the Difference Between Two Dates in Excel

How to Calculate the Number of Months Between Dates in Excel

How to Apply Conditional Formatting Based on Date in Excel