CODEWITHSUNDEEP
dateexcel-formulacomparegoogle-sheets-formula
Django Unchained
Django Unchained

Reputation: 105

Count the number of dates in a column that are greater than the current date in Google Sheets/Excel

I want to have a cell that checks a specific column for dates that are greater than today but for some reason it isnt counting.

Here is what I have:

=COUNTIF('ORDER DATE'!H3:H990;"<TODAY()")

Upvotes: 1

Views: 922

Answers (1)

kishkin
kishkin

Reputation: 5325

Try:

=COUNTIF('ORDER DATE'!H3:H990; ">" & TODAY())

Also notice that for greater than today you should use another operator: >.

Upvotes: 1

Related Questions