Hi Jerry

Try
=DATEDIF(A2,TODAY(),"y")



--
Regards Ron de Bruin
http://www.rondebruin.nl



"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