How to calculate the employee tenure in months or years in Excel?

When discussing the employment of any worker, the word Tenure will come up more frequently in discussion. The length of time that an individual has worked for one particular employer is referred to as their tenure. Simply said, an employee's length of service is what is meant by the term "tenure." Excel can be of assistance to us when it comes to calculating tenure or the average tenure of an employee.

If you are the one in charge of people tracking in our company or department, you could be wondering if you can use Excel to determine the number of months an employee has been employed by the company based on the date they started working there. This is something that is quite simple to accomplish.

This tutorial will present a straightforward formula for calculating tenure, the resulting value can be expressed either in months or years.

Using DATEDIF function

Excel's DATEDIF function calculates the difference between two date values and returns the result in either years, months, or days. The DATEDIF function is referred to as a compatibility function. The DATEDIF function is able to compute the amount of time in years, months, or days that has elapsed between two specified dates (a start date and an end date). The unit argument, which is passed in as text, is used to provide the information necessary to specify the time unit.

Let’s go through one example and see how the employee tenure is calculated using DATEDIF function step by step.

Calculating the Tenure in Months

Let's find out how you can use Excel to calculate the tenure of an employee in months.

Step 1

We have some name of the employees with their joining date in our excel sheet as shown in below given image. We are going to calculate the tenure of their employment comparing with the current date.

Step 2

Then select one blank cell next to the current date and add the below given formula in it. In our example we have selected the cell D2 and added the below given formula in it.

=DATEDIF(B2,NOW(),"M")

After adding the formula press enter to see the result.

In our example we have applied the formula for the value in cell B2. You can change the cell value as per your need. See the below given image.

Step 3

Pull the auto-fill handle all the way down to the cells where you want this formula to be applied. Check out this screenshot.

Calculating the Tenure in Years

Let's see how to use Excel to calculate the employee tenure in Years.

Step 1

Considering the above given example, if you want to know the tenure of the employee in years, add the below given formula to one blank cell.

In our example we have added the formula in E2 cell.

=DATEDIF(B2,NOW(),"Y")

After adding the formula press enter to see the result.

In our example we have applied the formula for the value in cell B2. You can change the cell value as per your need. See the below given image.

Step 2

Pull the auto-fill handle all the way down to the cells where you want this formula to be applied. Check out this screenshot.

Calculating the Tenure in Years and Months

Now let's see how to use Excel to calculate the tenure of an employee in Years and Months.

Step 1

Considering the above given example, if you want to know the tenure of the employee in years and months, add the below given formula to one blank cell.

In our example we have added the formula in F2 cell.

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

After adding the formula press enter to see the result.

You can change the cell value as per your need. See the below given image.

Step 2

To apply this formula to the cells of your choosing, drag the auto fill handle down to them. Take a look at the below given image.

Conclusion

In this tutorial, we demonstrated how you can use Excel to calculate tenure of an employee in years and months using DATEDIF function.