1 min readfrom 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

submitted by /u/shadow8164
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com