I assume you want the figure by using only one cell. If an employee started
on the 19th of May 1978 try
=(TODAY()-DATE(1978,5,19))/365.25
Regards,
"Jerry" wrote in message
...
I am trying to find a formula for determining years of service using a Hire
Date and then today's date without having another column for today's date.
I
enter my hire dates as mm/dd/yyyy and what to display years of service
only
(no months-days). How can I make that work?
Thanks,
Jerry