Calculating Months of Tenure

Summary: If you have an employee starting date, you can figure out how many months that employee has been working for your company. All you need to do is apply the DATEDIF function as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

If you are in charge of tracking employees in your department or company, you might want to know if you can use Excel to calculate the months of tenure for those employees, given the date at which the employee started. This can be done very easily.

For the sake of this example, let's assume that column C contains the starting date for a list of employees. You could use the following formula in column D to determine each employee's tenure:

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

The DATEDIF function calculates the difference between a starting date and an ending date. The "M" used in the formula indicates that you want the result in completed months.

To calculate the average tenure for your series of employees, simply include the following formula at the bottom of column C:

=AVERAGE(C3:C174)

Of course, you should replace the range in the function (C3:C174) with the actual range of employee tenures as determined by the DATEDIF formula.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2595) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.

Check out ExcelTips: Custom Formats today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Calculating Months of Tenure