Count if cell value

  • Thread starter Thread starter Clark Tidwell
  • Start date Start date
C

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
 
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
 
Back
Top