# Calculating Months of Tenure

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Calculating Months of Tenure.

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 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Calculating Months of Tenure.

Related Tips:

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit. Check out ExcelTips: Serious Sorting today!

Gary Lundblad    27 Aug 2012, 11:29
Thank you Lisa! This works great!

Gary
Lisa Johnson    24 Aug 2012, 10:32
Gary,

This should work

=DATEDIF(EOMONTH(C3,0),NOW(),"M"), provided C3 is where your original date is.
Gary Lundblad    18 Jul 2012, 10:10
What if you want to know the number of months from the end of the hire month? For example, the employee's hire date is Oct 21; I want to know the number of months from Oct 31.

Thank You!

Gary

 *Name: Email: Notify me about new comments ONLY FOR THIS TIP Notify me about new comments ANYWHERE ON THIS SITE Hide my email address *Text: *What is 3+4? (To prevent automated submissions and spam.)

# Our Company

Sharon Parq Associates, Inc.

# Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2013)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2013)

Excel Products

Word Products

# Our Authors

Author Index

Write for Tips.Net