Nelson,
If the formula returns the #NAME? error then you need to install the
analysis toolpak for the NETWORKDAYS function to work. Go to
ToolsAddins and check the Analysis ToolPak option. Click ok.
You also need to identify the federal holidays in your formula. Type
in the holidays in a range say D1:D5 and then your formula should look
like:
=NETWORKDAYS(A2,B2,$D$1:$D$5)
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=547163