CountIF Question
How do I get a formula to return the amount of cells that have a specific date?
Here's something I tried
=COUNTIF(B:E,"9/1/2006")
also
=COUNTIF(B:E,NOW()-5)
I get a big zero as the result
Here's what's in the cells...
9/1/2006 9:11:15 AM
Thanks in Advance,
Rob
|