'Calculate number of mondays in google spreadsheet
Can you please tell me how to count the number of Mondays in a column with dates in a Google spreadsheet?
Solution 1:[1]
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"))
Solution 2:[2]
Make sure your field is date format, then run this formula: A1 to A24 is your cells for calculation.
=SUMPRODUCT(--(WEEKDAY(A1:A24)=2))
Solution 3:[3]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Harun24hr |
| Solution 2 | Rafi Haidari |
| Solution 3 |