Hi Jerry,
If you activate the Analysis ToolPak (tools, add-ins) you can get the
"NETWORKDAYS" function, which does not include the weekends or holidays(when
listed). This is normally done to figure out pentionable time by HR
personnel.

Gilles

"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