Try

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,B1):INDEX(A:A,C1)),2)<6),--(ISNA(MATCH(ROW(INDIRECT(B1&":"&C1)),B45:B56,0))))

--
__________________________________
HTH

Bob

"HELP JOHNNY PLEASE" <HELP JOHNNY wrote in
message ...
Hello! I'm running across a problem with calculations -- i'm hoping i can
get a little help here. Some staff are not able to view my NETWORKDAYS
calculations due to excel 2002. It would be useless to have all 50+ staff
perform add-ins. Any thoughts? Also, I used another formula which came
up
with more days? Maybe due to 30 or 31 calendar days?

Here's an example of my formulas:
start (b1) = 09/01/09
end (c1) = 09/30/09
=NETWORKDAYS(B1,C1,B45:B56)
This comes out to 21 days

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,B1):INDEX(A:A,C1)),2)<6))--(ISNA(MATCH(ROW(INDIRECT(B1&":"&C1)),B45:B56,0)))
This comes out to 22 days

Help is greatly appreciated!