title: Count if date range fits within other date range
body: <p>I have a set of data with names of people who are on vacation for certain dates (Name, Start, End).</p>
  
  <p>Example:</p>
  
  <pre><code>Name     Start       End
  Joe      10-Jan-14   21-Jan-14
  Billy    12-Feb-14   10-Mar-14
  David    11-Jan-14   20-Jan-14
  Patty    10-Jan-14   19-Jan-14
  Megan    05-Jan-14   20-Jan-14
  
  -------------------------------
  Block    15-Jan-14   22-Jan-14
  </code></pre>
  
  <p>I want to count the number of people in the range who are going to be on vacation during the block dates.  It should return 4; <code>Joe</code>, <code>David</code>, <code>Patty</code> and <code>Megan</code>.</p>
  
  <p>The formula I have is:</p>
  
  <pre><code>=COUNTIFS(colStart, "&gt;="&amp;B1, colEnd, "&lt;="&amp;B2) 
  </code></pre>
  
  <p><code>colStart</code> and <code>colEnd</code> are named ranges of the Start and End column.</p>
  
  <p><code>B1</code> and <code>B2</code> are the block dates on my spreadsheet.  </p>
  
  <p>My problem is that it won't count someone who started before the block start date or ends after the block end date.. even though they will be on vacation during some point in the block dates. <code>Joe</code>, for example.. starts on <code>10 Jan</code>.  He will be on vacation still during the block dates.</p>
  
  <p>Visually I am comparing number lines.  I just need help to translate that to code.</p>