# How do I calculate how many years an employee has been working?

1. ## How do I calculate how many years an employee has been working?

I have a spreadsheet set up with an employees information, including the start date. After each year that the employee is working, he gets bumped up on the pay scale. For this reason, I only need to know how many years the employee has been working, rounded down to the nearest year.

This is what I have so far (hire date is in column B):

=((TODAY()-B4)/365)&" YEARS"

This function gives me a number with many decimal places.

I tried:

=ROUNDDOWN((TODAY()-B4)/365),0)&" YEARS"

2. I think the problem is the "years" in the formula. Try removing it and then use ,
=ROUND(D1,0) , it should give the number of years.

D1 being the cell with the formula (D1=((TODAY()-B4)/365))

3. You have one too many perentheses. Remove the red one:
``Please Login or Register  to view this content.``

4. Originally Posted by jasoncw
You have one too many perentheses. Remove the red one:
``Please Login or Register  to view this content.``
You were correct; it was such a simple error.

5. No problem.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1