Count if cell value
 

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

Count if cell value
 

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

Count if cell value
 

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

"Clark Tidwell" wrote:

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