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! D

=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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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! D
>
>