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 t...
=SUMPRODUCT(N(WEEKDAY($C$4:$C$22)=WEEKDAY(E4)))You can try this formula with the attached example.