Formula to count days

E

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
 
C

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
 
B

Bondi

Hi Els,

You could try to use the NetWorkDays()

It is in the Analysis ToolPak add-in

Regards,
Bondi
 
E

ELS

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


Chip Pearson said:
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
Click to expand...
 
Top