Formula to count days

[ELS]

Hi, Please help!
I'm trying to do a formula to count the number of business days (i.e.
Mon-Fri) between two dates that i have in Excel.

i tried the formula "=DAYS360(B2,C2, FALSE)" but this gives the total
number of days, not just work days. (i used this where B2=4-Apr-06 and C2 =
18-Apr-06.)

Does anyone know how i can calculate the number of work days?

Thank you!!!!!!!!!!!!!!!!!1
--
ELS

[Chip Pearson]

See the NETWORKDAYS function. It will take into account holidays
as well, if you provide it with a list of holidays. See help for
details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ELS" <[email protected]> wrote in message
news:[email protected]...
> Hi, Please help!
> I'm trying to do a formula to count the number of business days
> (i.e.
> Mon-Fri) between two dates that i have in Excel.
>
> i tried the formula "=DAYS360(B2,C2, FALSE)" but this gives
> the total
> number of days, not just work days. (i used this where
> B2=4-Apr-06 and C2 =
> 18-Apr-06.)
>
> Does anyone know how i can calculate the number of work days?
>
> Thank you!!!!!!!!!!!!!!!!!1
> --
> ELS

[Bondi]

Hi Els,

You could try to use the NetWorkDays()

It is in the Analysis ToolPak add-in

Regards,
Bondi

[ELS]

Awesome! Thank you so much, Bondi!!!
--
ELS


"Bondi" wrote:

>
> Hi Els,
>
> You could try to use the NetWorkDays()
>
> It is in the Analysis ToolPak add-in
>
> Regards,
> Bondi
>
>

[ELS]

It worked!! Thank you, Chip!!!!
--
ELS


"Chip Pearson" wrote:

> See the NETWORKDAYS function. It will take into account holidays
> as well, if you provide it with a list of holidays. See help for
> details.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "ELS" <[email protected]> wrote in message
> news:[email protected]...
> > Hi, Please help!
> > I'm trying to do a formula to count the number of business days
> > (i.e.
> > Mon-Fri) between two dates that i have in Excel.
> >
> > i tried the formula "=DAYS360(B2,C2, FALSE)" but this gives
> > the total
> > number of days, not just work days. (i used this where
> > B2=4-Apr-06 and C2 =
> > 18-Apr-06.)
> >
> > Does anyone know how i can calculate the number of work days?
> >
> > Thank you!!!!!!!!!!!!!!!!!1
> > --
> > ELS
>
>
>