title: Excel (Google Spreadsheet): get values between two dates
body: <p>I have seen lots of questions regarding this, on here and on other websites. However even with all that I have read I cannot accomplish what I want.</p>
  
  <p>I have an Excel document with in cell A2 a starting date and in B2 an end date.</p>
  
  <p>In A5:C11 I have a table with data. In cells A5:A11 I have dates, in B5:C11 I have the data. Now I want to display the data from B and C if they fall between the dates given in cells A2 and B2. I want to do so via a formula. I have tried many formulas with index, match, vlookup, small , sumproduct, if(s) and so on. Maybe any of you can help me?</p>
  
  <pre><code>Start date  End date    
  29-12-2017  29-12-2017  
  
  Date       Users    Pageviews
  04-01-2018  350         400
  03-01-2018  300         350
  02-01-2018  250         300
  01-01-2018  200         250
  31-12-2017  150         200
  30-12-2017  100         150
  29-12-2017  50          100
  </code></pre>
  
  <p>In this case I want the output to be, preferably in 3 cells:<br></p>
  
  <pre><code>29-12-2017  50  100
  </code></pre>