Count If Day of the Week

[Puzzlelover]

I have a spreadsheet with Column A as a date, Column B is the date from column A formatted to dddd.
I want to count the number of times each day of the week occurs in Column B of the spreadsheet. I tried Countif(B1:B17,D1), where D1 is Monday. My result is "0".

Any ideas?

[AlKey]

In C2

=SUMPRODUCT(--(WEEKDAY($A$2:$A$16)=DAY(B2)))

In B2 and numbers from 1 through 7

	A	B	C
1	Date	Day Name	Count
2	1/1/2013	Sunday	2
3	1/2/2013	Monday	2
4	1/3/2013	Tuesday	3
5	1/4/2013	Wednesday	2
6	1/5/2013	Thursday	2
7	1/6/2013	Friday	2
8	1/7/2013	Saturday	2
9	1/8/2013
10	1/9/2013
11	1/10/2013
12	1/11/2013
13	1/12/2013
14	1/13/2013
15	1/14/2013
16	1/15/2013

[daddylonglegs]

Column B still contains dates - COUNTIF counts the underlying value not the display. You can chnage column B to a formula like

=TEXT(A1,"dddd")

then your COUNTIF will work, or leave column B as is and use SUMPRODUCT with WEEKDAY function, e.g.

=SUMPRODUCT(--(WEEKDAY(A1:A17)=2))

[benishiryo]

welcome to the forum, puzzlelover. another alternative:
=SUMPRODUCT(--(TEXT($B$2:$B$16,"dddd")=C2))