How to Create Rolling 6 Months Average in Excel
But first you need the data for those six months, and this is something like this:
Click on an empty cell (1), and type
=AVERAGE($C$3:$C$3) (2), then press enter.
Click on cell D4 (1), then write
=AVERAGE($C$3:$C$4), and press enter.
Note: Follow this step on the rest using $C$3:$C$5 (April), $C$3:$C$6 (May), $C$3:$C$7 (June), and $C$3:$C$8 (July).
In conclusion, the steps we just followed is the moving average for the last six months. You can even use the result to create a chart, or as you wish.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References