Forum Discussion
count days of week
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 |
1 Reply
=SUMPRODUCT(N(WEEKDAY($C$4:$C$22)=WEEKDAY(E4)))You can try this formula with the attached example.
