Even if you didn't like my first attempt, you can still include holidays

=SUMPRODUCT((WEEKDAY(A2:A20)=2)*(NOT(ISNUMBER(MATC H(A2:A20,holidays,0)))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"harnagel" wrote in
message ...

I guess let's just forget Holidays, I would like to count how many
Mondays, Tuesdays, Wednesdays, Thursdays, Fridays, Saturdays, & Sundays
worked based on the data below:

Here's my columns:
Date Day (calculated formula) Data

11/1 Mon xyz
11/1 Mon xyz
11/2 Tue xyz
11/3 Wed xyz
11/4 Thur xyz
11/7 Mon xyz
11/14 Mon xyz

X Mondays
X Tuedays
X Wednesdays, etc.


--
harnagel
------------------------------------------------------------------------
harnagel's Profile:
http://www.excelforum.com/member.php...o&userid=29376
View this thread: http://www.excelforum.com/showthread...hreadid=490858