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

CountIF Question
 

Do this values are stored in cells in date format or as a text?

CountIF Question
 

=COUNTIF(B:E,"=9/1/2006")-Countif(B:E,"=9/2/2006")

--
Regards,
Tom Ogilvy


"Rob" wrote:

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

CountIF Question
 

Thank You Tom, That Worked Perfectly.

Rob

"Tom Ogilvy" wrote:

=COUNTIF(B:E,"=9/1/2006")-Countif(B:E,"=9/2/2006")

--
Regards,
Tom Ogilvy


"Rob" wrote:

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