Dec 13 2022 12:46 PM
I'm trying to count a range of cells that occurred today, the cells are formatted as follows 'MM/DD/YYYY HH:MM:SS).
example: 12/13/2022 10:56:39 AM.
The source of the data is from a MS form submersion.
Dec 13 2022 12:54 PM
Let's say the dates are in D2:D1000. Assuming that they are real dates, and not text values that look like dates, you can use
=COUNTIFS(D2:D1000,">="&TODAY(),D2:D1000,"<"&TODAY()+1)
Dec 13 2022 01:03 PM