I am tracking sales information & need to figure out how to track the last 8
weeks average sales.
Each week I add new sales & would like to be able to see how this changes
the averages without having to manually reset the formulas to add the new
week and drop the 9th week.

Thanks in advance for any help.