Moving Average Chart Daily Sales Ready Accessibility: Investigate Type here to search 1 Point XL Activity 8.04: Calculating Growth Based on a Moving Average In cell D16, enter a formula to calculate the growth rate from one Saturday to the next, based on the moving average and divided by the moving average for the previous Saturday.