Find maximum value between specified date range <p>I have a range of daily dates in column G and a range of stock prices in column H. I would like to find a rolling 52 week high, i.e. the highest stock price in column H between the current date and the same date 1 year prior.</p> <p>I am using the following formula: </p> <p><code>MAX(IF($G$5:$G$10757&gt;=EDATE(G5,-12),IF($G$5:$G$10757&lt;=G5,$H$5:$H$10757)))</code></p> <p>So, the IF conditions specify the date range as being in between G5 and G5 less 12 months, and is looking for the corresponding value in column H.</p> <p>After I type the formula, I press <code>CTRL+SHIFT+ENTER</code>. It seems to work for the first calculation, but I cannot fill the formula down for the entire range of dates. I just get the same value repeating over and over again.</p>