title: Average a range of values if the date associated with it falls within a date range
body: <p>I'm trying to average a range of values if its associated date falls between two specified dates.  The following function works:  </p>
  
  <p><code>AVERAGEIFS($1:$1,$2:$2,"&gt;=1/1/2014",$2:$2,"&lt;=1/2/2014")</code></p>
  
  <p>...in this case the values that you want to average are in row 1 and the dates that are associated with it are in row 2.</p>
  
  <p>However, in this case I'm explicitly stating the date range in my formula (">=1/1/2014" and "&lt;=1/2/2014").  Is there any way to create a similar formula that allows me to reference date cells to determine my date range instead of having to explicitly state the dates in the formula itself??? </p>