View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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