"COUNTIF" function for day of the week format [Closed]

Report

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.

"COUNTIF" function for day of the week format
How to format date in excel to include day of the week ✓ - Forum - Office Software
Help: Return day of the week ✓ - Forum - Excel
Countif function ✓ - Forum - Office Software
Countif day of week - Forum - Excel
How to stop today function date changing every day in excel - Forum - Excel

"COUNTIF" function for day of the week format [Closed]

Your reply

Subscribe To Our Newsletter!