Try one of these...

If you need to account for holidays...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B33&":"&B34)),2)<6),--(ISNA(MATCH(ROW(INDIRECT(B33&":"&B34)),C2:C10,0))) )

C2:C10 = list of holiday dates to be excluded.

If you don't need to account for holidays...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B33&":"&B34)),2)<6))

--
Biff
Microsoft Excel MVP


"Gabe" wrote in message
...
I have several people that are not familiar with the Analysis Toolpak, is
there a work around for the networkdays function? I just have two dates in
B33 (start date) & B34 (end date), so currently my formula is
=NETWORKDAYS(B33, B34). Is there a way to acheive the same result without
using the networkdays function?

Thanks in advance,
~Gabe