Formula to use new number every 7 rows

[pigsfoot]

Hi, Sorry this one is difficult to explain

I have a column full of numbers based on the date of a month, i.e. each lien is a date. These numbers are my base line

i want to increase those numbers using a decimal uplift which changes every 7 days.

The formula for the first set of 7 numbers would be J1*$B$1 ( J being the base figure and B being the uplift figures )
The next line would be J2*$B$1 and so on for 7 lines
The 8th line would be J8*$J$8

I need to do this for an entire year, so ultimately every 8th line i need to jump to a new uplift number. Hopefully that explains it.

So my question is, is there a formula i can use to do that considering i am locking the uplift number for a specific cell for 7 lines at a time?? I have added a screenshot of my sheet, teh column numbers ar eduifferent a steh obove is to try and explain things but it shows what i am trying to do.

Thanks

 

[fjns]

Hi, try this formula
=J1*INDEX(B:B,INT((ROW()-1)/7)*7+1)

 

[fjns]

Hi, of course the formula changes with 2 header rows.

without header rows the formula for K1:
=J1*INDEX(B:B,INT((ROW()-1)/7)*7+1)

with 2 header rows the formula for K3:
=J1*INDEX(B:B,INT((ROW()-3)/7)*7+3)

(On screenshots the formulas visible in hungarian language.)