Count Date/Days

[R1chard]

I have a column of dates, formatted to display the day. Format DDDD

When I used COUNTIF, and type Monday as my Criteria, or any other day. It does not find the day, due to the format.

I am also unable to copy and paste just the value. The Monday cell, copied and pasted as a value, displays as 45078.60625

What is the best way to count the number of Mondays, Tuesdays ect, from a column of dates?

 

[Joe4]

Yes, Excel formulas work off the actual underlying values, not on the formats applies to cells.
Try this to count Mondays:

=SUMPRODUCT(--(WEEKDAY(range)=2))

For other days, like Tuesdays, simply change the value of 2 (to 3 for Tuesdays).