title: Excel CountIf with finding number of certain dates
body: <p>I have a couple of sheets in workbook, once sheet as a list of client jobs with dates.</p>
  
  <p>On another sheet, I have a summery of jobs and other items. I want to know the tota # of jobs in 2011.</p>
  
  <p>Here's what I have and it's not working:</p>
  
  <pre><code>=COUNTIF(Jobs!A2:A50,"*2011")
  =COUNTIF(Jobs!A2:A50,"??????2011")
  </code></pre>
  
  <p>Neither of these give results, I wonder if it's because the cells are formated as dates in the Jobs sheet? 10/01/2011</p>