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?