Can you please tell me how to count the number of Mondays in a column with dates in a Google spreadsheet?
3 Answers
Make sure your field is date format, then run this formula: A1 to A24 is your cells for calculation.
=SUMPRODUCT(--(WEEKDAY(A1:A24)=2))
You may try FILTER() function.
=COUNT(FILTER(A2:A7,WEEKDAY(A2:A7)=2))
Or direct day name.
=COUNT(FILTER(A2:A7,TEXT(A2:A7,"dddd")="Monday"))
Create a new column with a formula like this:
=--(WEEKDAY(A1)=2)
where A1 is the date in your example.
That new column will contain a 1 for mondays, and 0 for anything else. From there you can just sum the new column to get the # of mondays.
Related