Spreadsheet: 748506d1632175168-prior-weeks-average-build-rate-formula-test1
Sheet: Sheet1

 |  |  |  |  |  | AVG Build Rate
Product ID | Start Date | End Date | Build Rate |  |  | 2 | <<<<< I want this cell to be the average of the past 7 days build rate.
1 | 2021-07-31 00:00:00 | 2021-08-03 00:00:00
2 | 2021-08-14 00:00:00 | 2021-08-25 00:00:00
3 | 2021-08-05 00:00:00 | 2021-08-09 00:00:00
4 | 2021-08-03 00:00:00 | 2021-08-12 00:00:00
5 | 2021-07-30 00:00:00 | 2021-08-03 00:00:00
6 | 2021-07-31 00:00:00 | 2021-08-03 00:00:00
7 | 2021-08-03 00:00:00 | 2021-08-05 00:00:00
8 | 2021-08-03 00:00:00 | 2021-08-05 00:00:00
9 | 2021-08-03 00:00:00 | 2021-08-06 00:00:00
10 | 2021-08-05 00:00:00 | 2021-08-07 00:00:00
11 | 2021-08-09 00:00:00 | 2021-08-12 00:00:00
12 | 2021-08-10 00:00:00 | 2021-08-14 00:00:00
13 | 2021-08-07 00:00:00 | 2021-08-10 00:00:00
14 | 2021-08-10 00:00:00 | 2021-08-12 00:00:00
15 | 2021-08-12 00:00:00 | 2021-08-16 00:00:00
16 | 2021-08-05 00:00:00 | 2021-08-07 00:00:00
17 | 2021-08-09 00:00:00 | 2021-08-11 00:00:00
18 | 2021-08-12 00:00:00 | 2021-08-14 00:00:00
19 | 2021-08-14 00:00:00 | 2021-08-18 00:00:00
20 | 2021-08-06 00:00:00 | 2021-08-09 00:00:00
21 | 2021-08-11 00:00:00 | 2021-08-14 00:00:00
22 | 2021-08-18 00:00:00 | 2021-08-20 00:00:00
23 | 2021-08-14 00:00:00 | 2021-08-17 00:00:00
24 | 2021-08-20 00:00:00 | 2021-08-24 00:00:00
25 | 2021-08-26 00:00:00 | 2021-08-28 00:00:00
26 | 2021-08-20 00:00:00 | 2021-08-23 00:00:00
27 | 2021-08-16 00:00:00 | 2021-08-18 00:00:00
28 | 2021-08-18 00:00:00 | 2021-08-20 00:00:00
29 | 2021-08-20 00:00:00 | 2021-08-23 00:00:00
30 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00
31 | 2021-08-23 00:00:00 | 2021-08-25 00:00:00
32 | 2021-08-24 00:00:00 | 2021-08-28 00:00:00
33 | 2021-08-18 00:00:00 | 2021-08-20 00:00:00
34 | 2021-08-24 00:00:00 | 2021-08-26 00:00:00
35 | 2021-08-24 00:00:00 | 2021-08-26 00:00:00
36 | 2021-08-26 00:00:00 | 2021-08-28 00:00:00
37 | 2021-08-27 00:00:00 | 2021-08-31 00:00:00
38 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00
39 | 2021-08-29 00:00:00 | 2021-09-01 00:00:00
40 | 2021-09-01 00:00:00 | 2021-09-09 00:00:00
41 | 2021-08-29 00:00:00 | 2021-08-31 00:00:00
42 | 2021-08-29 00:00:00 | 2021-09-01 00:00:00
43 | 2021-09-01 00:00:00 | 2021-09-03 00:00:00
44 | 2021-09-02 00:00:00 | 2021-09-04 00:00:00
45 | 2021-08-31 00:00:00 | 2021-09-02 00:00:00
46 | 2021-09-01 00:00:00 | 2021-09-03 00:00:00
47 | 2021-09-02 00:00:00 | 2021-09-04 00:00:00
48 | 2021-09-02 00:00:00 | 2021-09-04 00:00:00
49 | 2021-09-09 00:00:00 | 2021-09-14 00:00:00
50 | 2021-09-03 00:00:00 | 2021-09-11 00:00:00
51 | 2021-09-03 00:00:00 | 2021-09-10 00:00:00
52 | 2021-09-09 00:00:00 | 2021-09-15 00:00:00
53 | 2021-09-08 00:00:00 | 2021-09-11 00:00:00
54 | 2021-09-10 00:00:00 | 2021-09-14 00:00:00
55 | 2021-09-04 00:00:00 | 2021-09-10 00:00:00
56 | 2021-09-11 00:00:00 | 2021-09-14 00:00:00
57 | 2021-09-16 00:00:00
58 | 2021-09-14 00:00:00 | 2021-09-16 00:00:00
59 | 2021-09-14 00:00:00 | 2021-09-20 00:00:00
60 | 2021-09-14 00:00:00 | 2021-09-17 00:00:00
61 | 2021-09-13 00:00:00 | 2021-09-16 00:00:00
62 | 2021-09-16 00:00:00 | 2021-09-18 00:00:00
63 | 2021-09-16 00:00:00 | 2021-09-20 00:00:00
64 | 2021-09-17 00:00:00 | 2021-09-20 00:00:00
65 | 2021-09-20 00:00:00
66 | 2021-09-18 00:00:00
67 | 2021-09-20 00:00:00
68
69
70 | 2021-09-20 00:00:00