title: How to find data between two dates
body: <p>I do not use Excel regularly, hence I am unfamiliar with complicated formulas.<br>
    I have an Excel 2007 sheet like this:</p>
  
  <pre>
        A           B                  C
      Name      leavefrom          leaveupto
      Mathew    07-Mar-13          25-Mar-13
      john      12-Mar-13          15-Mar-13
      kerry     18-Apr-13          25-Apr-13
      Mikes     27-Jun-13          03-Jul-13
  </pre>
  
  <p>and I have a cell <strong>C10</strong> where I am providing a date value.  If I am providing 14-mar-13 then it should show the name "john" and "Mathew", if I provide 19-Apr-13 it should show "kerry", etc...  Basically, if I provide a date value it should find the names who are on leave on that particular date.</p>
  
  <p>Can someone help me find the correct formula?</p>