dynamic range combined with rolling average

Hi All,

I have a file with 52 columns (1 column for each week) with quantities. I need to show the rolling average for the last 6 weeks in column A and the rolling average for the last 10 weeks in column B. The tricky part is how to automatically update this when we have a new week.

See attached example file; the current week is week 11. Column A needs to be the average of week 5 up to week 10, column B needs to be the average of week 1 up to week 10.
Next week, we are in week 12, so the value in Column A needs to be the average of week 6 up to week 11, column B needs to be the average of week 2 up to week 11 and so on.

How to capture this in a formula?

Thanks for all the help!
rolling average.xlsx

=AVERAGE(OFFSET(E3,,COUNT(E3:ZZ3)-10,,10)) for 10 weeks

=AVERAGE(OFFSET(E4,,COUNT(E4:ZZ4)-6,,6)) for 6 weeks

aha, super!! many thanks!