title: Countifs Date is between two dates Google Sheets
body: <p>I have a cell A with the date of the beginning of the calendar week and a cell B with the end of the calendar week.</p>
  
  <p>No I want to count all the rows from a different sheet that contain a date within this calendar week.
  I have tried the following but it returns an error because it can't parse the formula.</p>
  
  <pre><code>=COUNTIFS('Other Sheet'!$H$1; &gt;A2; 'Other Sheet'!$H$1; &lt;B2)
  </code></pre>
  
  <p>Any advice?</p>