Jun 27 2022 09:32 AM
Hello - first-time poster here
I would like to count the number of Mondays, Tuesdays, Wednesdays, etc. My column is formatted to automatically show the day of the week when I type the date. So I type 6/26/22 and it displays Sunday, June 26, 2022. So when I try to use the countif function and Weekday function it is not recognized because the cell contains only numbers 6/26/22, but it displays the day of the week.
Friday, June 17, 2022 |
Monday, June 20, 2022 |
Tuesday, June 21, 2022 |
Thursday, June 23, 2022 |
Sunday, June 26, 2022 |
Sunday, June 26, 2022 |
Jun 27 2022 10:12 AM
=SUMPRODUCT(N(WEEKDAY($C$4:$C$22)=WEEKDAY(E4)))
You can try this formula with the attached example.