Count Cells with date and time that occurred today

Copper 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


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



Thank you! This is what I needed.