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

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

=COUNTIF(A1:A12,""&TODAY())

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Dan Bork" wrote in message
...
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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004