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" wrote in message
...
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