•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting date entries in csv spreadsheet
I have entries similar to the ones below. I have 1500 rows of data. Out of this, all I care about is how many entries I got each day. So for 8/19/2025 id like it to return 2, 8/20/2025 it returns 4 and so on. I was going to do a countif command using =COUNTIF(B2:1479, 8/19/2025) then =COUNTIF(B2:1479, 8/20/2025) but it returns 0 for both. I assume its looking at the time in the value so it does not meet the criteria.
8/19/2025 13:51:20 PM
8/19/2025 18:52:01 PM
8/20/2025 10:42:01 AM
8/20/2025 10:43:01 AM
8/20/2025 10:43:01 AM
8/20/2025 15:06:01 PM
1/20/2026 3:07:01 AM
[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
#rows.com
#natural language processing for spreadsheets
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#real-time collaboration
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software