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" 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