count days of week

Copper Contributor

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

@abgreen 

=SUMPRODUCT(N(WEEKDAY($C$4:$C$22)=WEEKDAY(E4)))

You can try this formula with the attached example.