•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting / Summing Dates (in Google Sheets)
Our take
Counting events by day of the week in Google Sheets can streamline your data analysis and enhance your productivity. To determine how many occurrences fall on each day, you can leverage functions like `COUNTIF`. If your dates are formatted in column A, you can easily tally the events for each weekday. Alternatively, if you need to extract formatted text, a simple command in cell B1 can copy the text from column A. This approach allows you to efficiently filter and analyze your data.
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]
Read on the original site
Open the publisher's page for the full experience