Google Spreadsheet COUNTIF TODAY()?
excel, excel-formula, google-sheets
Solution
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.
Problem
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?