"Harlan Grove" wrote in message
...
"T. Valko" wrote...
...
How about a replacement formula that doesn't depend on the ATP?

A1 = start date
B1 = end date
C1:C5 = holiday list (if you're using the Holidays argument)

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6),
--(ISNA(MATCH(ROW(INDIRECT(A1&":"&B1)),C1:C5,0))))

If you're not using the Holidays argument:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6))
...

Yucky volatile functions!

Yeah, but it's only a single formula. Of course, we don't know if they need
1000's of these.

--
Biff
Microsoft Excel MVP