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"
It tells me I have too few arguments. Please help!
Bookmarks