title: EXCEL - CountIfs between dates formula
body: <p>I am attempting to count the amount of values in a column that fall between certain dates.
  (Note: There are lots of N/As in the columns).</p>
  <p>I have dates inputted into the cells which I can reference as the min and max date.</p>
  <p>Please see my formula below. What I suspect is that the column I'm counting has a different data type that the dates I'm referncing. I have tried formatting all dates to be of the same type but to no avail unfortunately.</p>
  <p><strong>A1 = 01/01/2020</strong> <br/>
  <strong>A2 = 31/12/2020</strong></p>
  <pre><code>=COUNTIFS($K$5:$K$100,&quot;&gt;=&quot;&amp;A1, $K$5:$K$100,&quot;&lt;=&quot;&amp;A2)
  </code></pre>
  <p>Thanks</p>