Assume the dates are in A1:A1000

=SUMPRODUCT(--(WEEKDAY(A1:A11000,2)=3))

for Wednesday

if there might be blank cells and you are counting Saturdays you might want
to use


=SUMPRODUCT(--(WEEKDAY(A1:A1000,2)=6),--(ISNUMBER(A1:A1000)))

since otherwise blank cells will be counted as Saturdays


--


Regards,


Peo Sjoblom



"Brian FL" <Brian wrote in message
...
I have a column with dates formated as: Wednesday, November 14, 2007. I
would like to count how many where Wed., Thur. and so on.

How do I do that? The column covers event dates for 3 years.