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.

14 A B C D 1 Daily Sales Totals - July 2018 2 Date Sales Totals 3 Sun, Jul 01 $ 4,438.20 #N/A 4 Mon, Jul 02 $ 3,705.00 #N/A 5 Tue, Jul 03 $ 4,361.50 #N/A 6 Wed, Jul 04 $ 6,041.10 #N/A 7 Thu, Jul 05 $ 4,838.60 #N/A 8 Fri, Jul 06 $ 3,972.80 #N/A 9 Sat, Jul 07 $ 4,193.80 $ 4,507.29 10 Sun, Jul 08 $ 4,638.40 $ 4,535.89 11 Mon, Jul 09 $ 4,191.20 $ 4,605.34 12 Tue, Jul 10 $ 5,751.20 $ 4,803.87 13 Wed, Jul 11 $ 7,177.30 $ 4,966.19 Thu, Jul 12 $ 7,558.20 $ 5,354.70 15 Fri, Jul 13 $ 5,660.20 $ 5,595.76 16 Sat, Jul 14 $ 4,270.50 $ 5,606.71 Sun, Jul 15 $ 4,642.30 $ 5,607.27 Mon, Jul 16 $ 4,644.90 $ 5,672.09 19 Tue, Jul 17 $ 6,007.30 $ 5,708.67 20 Wed, Jul 18 $ 7,835.10 $ 5,802.64 21 Thu, Jul 19 S 10,717.20 $ 6,253.93 22 Fri, Jul 20 $ 6,276.40 $ 6,341.96 23 Sat, Jul 21 $ 4,408.30 $ 6,361.64 24 Sun, Jul 22 $ 4,191.20 $ 6,297.20 25 Mon, Jul 23 $ 6,146.40 $ 6,511.70 26 Tue, Jul 24 $ 6,431.10 $ 6,572.24 27 Wed, Jul 25 $ 11,021.40 $ 7,027.43 28 Thu, Jul 26 $ 10,745.80 $ 7,031.51 29 Fri, Jul 27 $ 6,903.00 $ 7,121.03 30 Sat, Jul 28 $ 6,000.80 $ 7,348.53 31 Sun, Jul 29 $ 3,980.60 $ 7,318.44 32 Mon, Jul 30 $ 4,659.20 $ 7,105.99 33 Tue, Jul 31 $ 6,687.20 $ 7,142.57 34 17 18