Re: How do I calculate the number of business days?

Giganews Newsgroups
Subject: Re: How do I calculate the number of business days?
Posted by:  SteveG (SteveG.28ongn_1149097202.2674@excelforum-nospam.com)
Date: Wed, 31 May 2006

Nelson,

If the formula returns the #NAME? error then you need to install the
analysis toolpak for the NETWORKDAYS function to work.  Go to
Tools>Addins 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?action=getinfo&userid=7571
View this thread:http://www.excelforum.com/showthread.php?threadid=547163

Replies

None

In response to

How do I calculate the number of business days? posted by Nelson on Wed, 31 May 2006