Try it like this:

A1 = some date

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

--
Biff
Microsoft Excel MVP


"Clark Tidwell" <Clark wrote in message
...
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