I have column with dates in column U. I changed them to "ddd" format, so now they are Mon, Tue etc.
I am trying to count how many times
Mon is in cells between cell
=COUNTIF(U2:U1048576,"Mon"). Result is always 0. I tried same thing but searching for a number and it works. How do I do same thing for weekdays ?