•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting / Summing Dates (in Google Sheets)
I want to count how many events occur on which days of the week.
The data below would create the following result;
Mon=1
Tue=0
Wed=0
Thu=1
Fri=1
Sat=0
Sun=0
Is it possible to retrieve this data from the formatted text result. The data in the cells are 16/03/2026, 19/03/2026, 20/03/2026. The date column is column A.
Failing that, is it possible to have a command in B1 that will automatically copy all the text from A. The formatted text, not the contents. Because then I can just ask for cells including "Mon" with
=COUNTIF(A2:A340, "*Mon*")
(crossposted to r/googlesheets , will reply with answer if found there)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#google sheets