How to calculate # days between business days

[Susan Hayes]

Hello

I am trying to calculate the number of business days between two dates:

For example

Between Sept 2 /05 and Sept 7 /05 there are a total of 3 business days (not including Weekends and Holidays).
How do you calculate this?

Thank you,

Susan

 

[JMB]

you might consider using NETWORKDAYS function.

=NETWORKDAYS(start_date, end_date, holidays)

the holidays argument is a reference to a list of holidays you want
excluded. Labor Day would have to be calculated.

=DATE(YEAR(TODAY()),9,7-WEEKDAY(DATE(YEAR(TODAY()),9,1),2)+2)

 

[slc]

Use Excel function

=NETWORKDAYS(A1,B1,Holidays)

where
Cell A1 = Start date (2 Sep)
Cell B1 = End date (7 Sep)
Holidays = name range containing all the public holidays in the year.