Calculate the number of workdays between 2 dates
 

Dave R.
Thanks for the quick help, that did the trick! Do you know if there is
a way to have it not count holidays also? If so can you enter in a
custom holiday calendar?


--
Tegid77
------------------------------------------------------------------------
Tegid77's Profile: http://www.excelforum.com/member.php...o&userid=16087
View this thread: http://www.excelforum.com/showthread...hreadid=275376

Tegid77 Wrote:
Dave R.
Thanks for the quick help, that did the trick! Do you know if there is
a way to have it not count holidays also? If so can you enter in a
custom holiday calendar?

=NETWORKDAYS(Date1,Date2,Holidays)

where Holidays refers to a range housing known holiday dates.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275376

Did you try Help for this function. It answers your question.

On Thu, 4 Nov 2004 13:54:46 -0600, Tegid77
wrote:


Dave R.
Thanks for the quick help, that did the trick! Do you know if there is
a way to have it not count holidays also? If so can you enter in a
custom holiday calendar?