title: COUNTIF for date is within the current week and for in the last week
body: <p>I am creating a refreshable spreadsheet which pulls activities from SQL queries.</p>
  
  <p>On the first page I need a formula that counts all the occurrences of a contact method that falls in the current week and the count of all occurrences that fall in the previous week.</p>
  
  <p>Here is what my data set looks like:</p>
  
  <pre><code>Contact Employee  Date              Method  
  Jack    John      12/16/15          Email
  Jack    John      12/7/15           Email
  Jill    John      12/9/15           Call
  Rick    Amber     12/8/15           Call
  Dave    Sarah     12/10/15          Email
  Dave    Sarah     12/15/15          Call
  Dave    Sarah     12/9/15           Email
  Don     Amber     12/14/15          Call
  </code></pre>
  
  <p>What I want is for the data to return like this:</p>
  
  <pre><code>TimeFrame      #ofCalls  #ofEmails
  Current Week      2          1
  Last Week         2          3
  </code></pre>
  
  <p>I want to use a formula that looks for dates that fall with the current week and counts the occurrence and then another formula that looks for dates that fall within the prior week and counts the occurrences in that week.</p>
  
  <p>I'd like the formula to stay the same so if I refresh the sheet each day, I don't have to change the date range in the formula.</p>