COUNTING DATE

[Eugo29]

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.

[#2 · Accepted solution]

@Eugo29 

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.

[#3]

Thank you very much. It worked!!

[#4]

@Eugo29 , you are welcome, glad it helped