How do I calculate the number of business days?

Giganews Newsgroups
Subject: How do I calculate the number of business days?
Posted by:  Nelson
Date: Wed, 31 May 2006

I have Microsoft Excel 2000 on my work computer and I am trying to calculate
the number of business days in a specified period.  I don't want to count
weekends or federal holidays.  I found the following formula but it does not
work so I am assuming that it is for a later version.

=NETWORKDAYS(A2,B2)

A2 is the beginning date (i.e., 04/01/2006) and B2 is the ending date (i.e.,
10/01/2006).

Is there a way to do such a calculation?

Replies