Forum Discussion
Count Cells with date and time that occurred today
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.
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.
