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?
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?