title: EXCEL Get a subset of rows from a column of date without VBA
body: <p>I have multiple sheets of data with the date in column A and a value in column B.
  I want to plot the same shifting date range from all sheets (e.g. the past seven days) - so that I can compare the data in one chart. However, the data's "spacing" isn't always the same, so I can't just plot the same number of rows for each sheet.</p>
  
  <p>I've figured out ways to find the rows I want. This gives the first entry for seven days ago:</p>
  
  <pre><code>=LOOKUP(TODAY()-8,sheet1!A:A,ROW(sheet1!A:A))+1
  </code></pre>
  
  <p>Then I use the COUNT function to get the last value. Now I want to plot the data in this range.</p>
  
  <p>I've tried named ranges but I can't seem to get it to work. Anybody have an idea?</p>
  
  <p>Best regards,
  Andrew</p>