Count of Sundays

[sick stigma]

In the attached workbook, I need to count the number of occourances of each day of the week. Any help would be greatly appreciated!
Sick

[Haseeb Avarakkan]

Try,

=SUMPRODUCT((TEXT($B$12:$B$100,"ddd;;;")="Sun")+0)

Adjust the range & Days

[FDibbins]

see if the attached is what you want?

[Cutter]

Try
=SUMPRODUCT(--(WEEKDAY(B12:B100)=1))

[sick stigma]

Found my problem! Cell must be formatted to number, not date! Duh!!
Thanks to all for your suggestions!
Solved "Regrettably, each suggestion returns a date (Friday, January 06, 1900),
not a count or sum of count. What am I doing wrong??????"

[Ron Coderre]

Using your posted workbook, here's one approach for counting Saturdays:
B5: =SUMPRODUCT((WEEKDAY(B12:B112)=7)*(B12:B112>0))

Is that something you can work with?

[daddylonglegs]

that's just a formatting issue, format cell with formula as general