Formula to count days

[Guest]

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

 

[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

 

[Bondi]

Hi Els,

You could try to use the NetWorkDays()

It is in the Analysis ToolPak add-in

Regards,
Bondi

 

[Guest]

Awesome! Thank you so much, Bondi!!!

 

[Guest]

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

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