Hello,

I want to calculate the previous 7 cells, before the formula cell. But my formula cell is changing weekly, so it carriers the previous 7 cells plus the 1 added per week.

So how can I have a formula that does just a set prevoius number of cells??

Thank you.