CODEWITHSUNDEEP
excel-2010
Ryan Hubbard
Ryan Hubbard

Reputation: 39

Excel 2010 Formulas to count data entry for the day

Each of my entries into my log contain the date it was entered. I would like to make a counter to count all the listings i did today. The formula i was using is CountIf with E being the range, and the criteria pointing to a cell with the =NOW() formula. .....Doesnt work. Any help?

Upvotes: 0

Views: 35

Answers (1)

user1274820
user1274820

Reputation: 8144

You can use TODAY() and COUNTIF()

=COUNTIF(E:E,"="&TODAY())

Today

Upvotes: 0

Related Questions