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

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)


"Susan Hayes" wrote:

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

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.


--
slc
------------------------------------------------------------------------
slc's Profile: http://www.excelforum.com/member.php...fo&userid=1439
View this thread: http://www.excelforum.com/showthread...hreadid=465791