Count Cells with date and time that occurred today

New Contributor

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. 

2 Replies

@DANMERZ 

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)

Thank you! This is what I needed.