New Contributor

Beginner: Please help me count entries within today (6/9/2021). I've tried COUNTIF TODAY(), nothing works. Sometimes, gives me Zero (0) as answer. This is for an excel file, connected to a form. Needs to count new entries submitted on the current date. Thank you.


Screen Shot 2021-06-12 at 12.19.28 pm.png


3 Replies
best response confirmed by Eugo29 (New Contributor)


That could be like

=COUNTIFS(range, ">=" & TODAY(), range, "<" & TODAY()+1)

In Excel dates are actually sequential integer numbers starting from 1 which is 01 Jan, 1900. Time is decimal part (1  Hour = 1/24). TODAY() retunes integer number corresponded to current date.

Thank you very much. It worked!!

@Eugo29 , you are welcome, glad it helped