Hello! I am calculating a 4 week moving average in column B and would like to display the rolling date range in column A. Currently I have the below dates manually entered but I would like to be able to just drag down to autofill the date range in the future. Is there a formula that would allow me to accomplish this? Thank you!
| 1/3/21 - 1/24/21 | 74.53% |
| 1/10/21 - 1/31/21 | 70.02% |
| 1/17/21 - 2/7/21 | 70.29% |
| 1/24/21 - 2/14/21 | 75.47% |
| 1/31/21 - 2/21/21 | 85.98% |
| 2/7/21 - 2/28/21 | 83.29% |
| 2/14/21 - 3/7/21 | 82.39% |
| 2/21/21 - 3/14/21 | 79.88% |
| 2/28/21 - 3/21/21 | 76.26% |
| 3/7/21 - 3/28/21 | 77.76% |
| 3/14/21 - 4/4/21 | 73.15% |
| 3/21/21 - 4/11/21 | 64.43% |
| 3/28/21 - 4/18/21 | 51.21% |
| 4/4/21 - 4/25/21 | 48.94% |
| 4/4/21 - 5/2/21 | 48.86% |
| 4/11/21 - 5/9/21 | 53.00% |
| 4/18/21 - 5/16/21 | 61.51% |
| 4/25/21 - 5/23/21 | 67.92% |
| 5/2/21 - 5/30/21 | 74.70% |
| 5/9/21 - 6/6/21 | 78.88% |
| 5/16/21 - 6/13/21 | 73.30% |
| 5/23/21 - 6/20/21 | 72.37% |
| 5/30/21 - 6/27/21 | 71.25% |
