March 16, 2026•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;

https://preview.redd.it/qofb3ncnpfpg1.png?width=127&format=png&auto=webp&s=ad59949b8df291c296adccf103928934cb3b9cba

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)

submitted by /u/Objective-Angle-6574
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Countifs function comparing the number of occurrences of a value within a date range without having to change the date for every cell?https://preview.redd.it/5wv7p6qq6dvg1.png?width=1523&format=png&auto=webp&s=8678f87180d0cf5c410d2f14fdaefc77ca4dc255 I am a self-taught excel newbie and am trying to help automate the calculation of the stats at my job (meaning I will likely be back with multiple more questions). For this problem, I am trying to get the data to automatically calculate as information is entered in another sheet to determine how often certain values (e.g. "Academic") appear within each month. For some reason, when I put the cell (H2) in place of the date, excel does not register it as a cell and will not complete the calculation. The only solution I have found is to have to individually type out each date range rather than referring to the cell that contains the date range. Further, is there a way to not have to include the year? in this job, we have a separate file for every school year meaning there will be no overlap of month causing issues that way. I am trying to find an easier way to do a year to year comparison without having to include helper columns with the beginning and end dates of each month per year. https://preview.redd.it/55l3ixa49dvg1.png?width=1140&format=png&auto=webp&s=3b222fe0266778a2645f72fed52b59efae4ed850 Thank you! submitted by /u/mentallylost14 [link] [comments]

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

Counting / Summing Dates (in Google Sheets)

Related Articles

Tagged with