•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
#rows.com