•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
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#google sheets
#Excel alternatives
#Google Sheets
#count
#COUNTIF