Google Spreadsheet COUNTIF TODAY()?

Question

Is there any way to COUNTIF it's the current date?

For example I have a spreadsheet with work orders, once the employee starts the work order it captures a time stamp, after the work order is completed it is moved to an archive, well I wanted to create a summary sheet that tells me how many orders we have done for that date, the format of the time stamp is:

2/19/2014 17:10:20

So basically I need a COUNTIF to count the column for the current date.

Is this possible?

Solution 1

You would need to apply a function first on the range, which then makes COUNTIF not an appropriate function to count those dates matching 'today'. You can use SUMPRODUCT instead:

=arrayformula(SUMPRODUCT(1*(INT(A1:A100)=TODAY())))

INT strips out the time from the datetime.

Solution 2

The new version of Google Sheets has COUNTIFS, which would allow =COUNTIFS(A:A,">="&TODAY(),A:A,"<"&TODAY()+1)

You need to opt in to the new version to make it work, though. ("Try the new Google Sheets")