Previous Topic Next Topic

"COUNTIF" function for day of the week format

Closed
hangomango
Posts
2
Registration date
Thursday January 23, 2014
Status
Member
Last seen
January 23, 2014
 - Jan 23, 2014 at 03:04 PM
I have a column of dates, where the formatting I've set for "Day of the week, month, day, year".

How do I run a COUNTIF function for Mondays, Tuesdays...etc? I tried the running it, but because the formatting in the formula bar is ex: "01/02/13", it doesn't pick up the text in the formatted column. My formula, =COUNTIF(range, "Monday") returns "0" even though there are about 125 instances.