countif(a1:a12,">TODAY()") How do I get this to work?

D

Dan Bork

Have a column of dates and I want to count the number of dates in the column
that are greater than today's date. Tried using the countif function as
above to no avail.

Is there another function to use or a way to change how I am specifying the
criteria?

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
countifs Function not giving desired result with date criteria 2
Using <= in countifs statement 1
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Excel 2010 countifs for date range 3
COUNTIFS with a date for criteria... 1
Countif function 3
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1

Top