Calculating # of busn days, not just calendar days, between 2 dates?
 

Phew, I keep coming across things I don't know how to resolve. A
spreadsheet I set up for holiday leave last week works great but I just
realized that we need to know not just the number of days between a start
and end date, but also the # of business days. The code for calendar days
was easy, since it's just a subtraction formula, basically. i.e., between
7/28/2004 and 8/13/2004, there are 16 calendar days. By counting manually
on paper calendars, I see that there are 12 business days between those 2
dates, if I've counted correctly.

How would one code that in a formula, though, pls?

Thank you! Where would I be without this fabulous ng and all you great MVPs
and other out there! :oD

Calculating # of busn days, not just calendar days, between 2 dates?
 

=NETWORKDAYS(E1,E2)

If you want to exclude hoilidays, put in another rantge and use

=NETWORKDAYS(E1,E2, range_of_dates)

This is part of the Analysis Toolpak Addin, so make sure that is enabled.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"StargateFanFromWork" wrote in message
...
Phew, I keep coming across things I don't know how to resolve. A
spreadsheet I set up for holiday leave last week works great but I just
realized that we need to know not just the number of days between a start
and end date, but also the # of business days. The code for calendar days
was easy, since it's just a subtraction formula, basically. i.e., between
7/28/2004 and 8/13/2004, there are 16 calendar days. By counting manually
on paper calendars, I see that there are 12 business days between those 2
dates, if I've counted correctly.

How would one code that in a formula, though, pls?

Thank you! Where would I be without this fabulous ng and all you great
MVPs
and other out there! :oD