I have a spreadsheet where a new set of data is entered each week of the year. Future columns are left blank until that weeks data is entered.

There is an average column already but I would like to add a new column for a running 8 week average which recalculates as each weeks new data is entered. How do I find out the latest 8 weeks in a formula?