title: Dynamic Range for Average Calculation
body: <p>I am trying to come up with an Excel Formula to calculate 6 Months average value from Monthly prices.
  A year is considered from April 2022 to March 2023 and so on. That means from April 2022 to Sept 2022 it is Half 1 and Oct 2022 to Mar 2023 it is Half 2.
  Total time line is till <strong>March 2055</strong>. So, the formula has to be dynamic.</p>
  <p>Please advise how I can use a formula for this averaging task.
  The Data table look like below.</p>
  <p><strong>INPUT</strong>
  Please refer the link to picture</p>
  <p><strong>OUTPUT</strong>
  In Yellow in the picture below</p>
  <p><a href="https://i.stack.imgur.com/AkJPl.png" rel="nofollow noreferrer">Table Pic</a></p>
  <p>Thank you!</p>