title: How to change these hard-coded cell references to dynamic references?
body: <p>I have this spreadsheet:</p>
  
  <p><a href="https://i.stack.imgur.com/KeDnr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KeDnr.png" alt="enter image description here"></a></p>
  
  <p>and I have the following formula, which gets me exactly the results I need:</p>
  
  <p><a href="https://i.stack.imgur.com/9gFGa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9gFGa.png" alt="enter image description here"></a></p>
  
  <p>The problem I have is with the cell references being hard coded.  I need it all to be dynamic, because the information I'm targeting is based on the date. Today I need the information in rows 23-28. tomorrow it could be rows 5-10 or rows 30-40.</p>
  
  <p>How can I look through the entire column A to find today's date, and then display only the rows of information pertaining to that date? I can do it with hard-coded row numbers, but I can't figure out how to do this with dynamic row numbers.</p>