Hi All,

I am trying to calculate the last three weeks averaged values in rows 5-6 in the attached workbook if those values are greater than zero but cannot seem to figure out how to have the average update given the current date. I have weeks and week numbers listed out in rows above but am not familiar enough with offset, match, index functions to use some other methods I saw posted here. Does anyone have suggestions for how to proceed?

rolling averages.xlsx