Hi Ron!

Did you test this if
1. A holiday date is outside of the range A1:B1?
2. A holiday date falls on a Saturday or Sunday?

Why would someone list a holiday date outside the range?

I would assume that people only list those holidays that
would fall on a business day. I'll bet most people have to
look at a calander to see when the holidays occur.

Biff

-----Original Message-----
On Thu, 10 Mar 2005 23:11:59 -0800, "Biff"
wrote:

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

Did you test this if
1. A holiday date is outside of the range A1:B1?
2. A holiday date falls on a Saturday or Sunday?


--ron
.