View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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