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):
This function gives me a number with many decimal places.
It tells me I have too few arguments. Please help!
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))
You have one too many perentheses. Remove the red one:
You were correct; it was such a simple error.
Originally Posted by jasoncw
Thanks for your help!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1