Function to calculate the Length of Service of an Employee
=DATEDIF(A1,A2,"y")
Where A1= date of hire, and A2=date of reference (could be TODAY() for
example).
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.
"Grd" wrote:
Hi there,
I have the Date Of Hire for my employees and I was wondering if there was a
built in function to give the the length the employee has been in the company
in whole years.
Any help would be greatly appreciated.
Tx
Suzanne
|