title: Can I use the CountIf function to count the # of cells containing certain date keywords?
body: <p>I have a set of data that looks something like this:</p>
  
  <p>11/8/12 5:20</p>
  
  <p>11/7/12 15:57</p>
  
  <p>11/7/12 13:51</p>
  
  <p>11/7/12 10:47</p>
  
  <p>11/7/12 8:00</p>
  
  <p>Just in Excel, I want to be able to count the number of rows with 11/8/12, and the number of rows beginning in 11/7, etc. I have a pretty long list of dates and times, but I'm only interested in the dates. </p>
  
  <p>I tried =COUNTIF(A1:A235, "&lt;11/8/12 5:20") to get everything before 11/8, but obviously this doesn't work because I need to type in the time. Does anyone know how to:</p>
  
  <p>1) make the timestamp irrelevant?
  2) somehow search for rows that "contain" a certain date value and count up the rows that contain that value?</p>