You can use one of the following formulas to calculate employee tenure in Excel:

**Formula 1: Calculate Tenure in Years and Months (e.g. 14 years, 2 months)**

=DATEDIF(B2,C2,"y") & " years , "& DATEDIF(B2,C2,"ym") & " months"

**Formula 2: Calculate Tenure in Years as Decimal (e.g. 14.16944 years)**

=YEARFRAC(B2, C2)

Both formulas assume that the start date is in cell **B2** and the end date is in cell **C2**.

The following examples show how to use each formula in practice with the following dataset in Excel:

**Example 1: Calculate Tenure in Years and Months**

We can type the following formula into cell **D2** to calculate the tenure for the first employee in terms of years and months:

=DATEDIF(B2,C2,"y") & " years , "& DATEDIF(B2,C2,"ym") & " months"

We can then drag and fill this formula down to each remaining cell in column D to calculate the tenure for each employee:

The values in column D display the tenure for each employee in terms of years and months.

If you simply want to display the tenure in terms of total days, you can use the following formula instead:

=DATEDIF(B2, C2, "d")

This will display the tenure in terms of days instead of years and months.

For example, the tenure for the first employee will be shown as 5,173 days.

**Example 2: Calculate Tenure in Years as Decimal**

We can type the following formula into cell **D2** to calculate the tenure for the first employee in terms of years as a decimal:

=YEARFRAC(B2, C2)

We can then drag and fill this formula down to each remaining cell in column D to calculate the tenure for each employee:

The values in column D display the tenure for each employee in terms of years as a decimal.

For example:

- Andy has a tenure of
**14.169 years**. - Ben has a tenure of
**3.894 years**. - Charles has a tenure of
**9.281 years**.

And so on.

**Note**: You can find the complete documentation for the Excel **YEARFRAC** function here.

**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