Hi,

In sheet 2 I want a formula in cell F2 to reference to sheet 1 cell E6. This formula I should be able to autofill the whole colom of F in sheet 2 where the value for F3(sheet2) = E13. So there need to be a jump for 7 days always.

F2= 149
F3= 231
F4= 320
....

Anyone knows what formula to use?

Thx!

Voorbeeld.xlsx