Hi Jerry

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



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



"Jerry" <Jerry@discussions.microsoft.com> wrote in message news:2A1C4774-8132-4114-B302-7825B113D2EB@microsoft.com...
>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