My iMac have system version 10.15.6 and Numbers version 10.1. I have daily data in Table 1, first column Date and second column Units. In Table 2, my first column is the beginning of a week date calculated from the Date Column in Table 1. I want to calculate the weekly unit averages for the second column of Table 2. In Excel I would embed average equation that would cover the most recent 7 daily values. Can one embed math operations that will change the cell references?