Count if cell value

[Clark Tidwell]

I am trying to use the folowing formula =COUNTIF(C2:C7,">8-19-09"). It works
however, I would like to change the criteria to either today() or have it
look a specific cell where I can change the date. When I try it the value
goes to 0. Thanks for your time. Clark

 

[T. Valko]

Try it like this:

A1 = some date

=COUNTIF(C2:C7,">"&A1)

 

[Tom Hutchins]

To always compare to today(), try

=COUNTIF(C2:C7,">"&TODAY())

To compare to a date in another cell (for example, G1), try

=COUNTIF(C2:C7,">"&G1)

Hope this helps,

Hutch