View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default How do I calculate the number of business days?


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