Dragging across formula

[handofthrawn]

Currently I have thousands of cells of data in columns A and B I need to calculate.

My C column looks like this.
C1 = (A2/$A$1) - (B2/$B$1)
C2 = (A3/$A$1) - (B3/$B$1)
C3 = (A4/$A$1) - (B4/$B$1)
...

I want to be able to drag C1 across D1, E1, etc get it to look like this
D1 = (A7/$A$6) - (B7/$B$6)
E1 = (A12/$A$11) - (B12/$B$11)
F1 = (A17/$A$16) - (B17/$B$16)
...

This allows me then to drag down the formulas of D1, E1, F1, and so on. Its skipping 5 rows, essentially a week of data, for each calculation. I've tried to search this problem but I can't solve it. Would I need to use VBA or could I use INDEX or Offset? I'm kind of at a loss and hoping someone could point me in a logical direction. Thanks for any help!

 

[Eric W]

Try putting this in C1, then copy down and to the right as far as needed.

=OFFSET($A2,(COLUMNS($B$1:B1)-1)*5,0)/OFFSET($A$1,(COLUMNS($B$1:B1)-1)*5,0)-(OFFSET($B2,(COLUMNS($B$1:B$1)-1)*5,0)/OFFSET($B$1,(COLUMNS($B$1:B$1)-1)*5,0))

 

[handofthrawn]

It worked perfectly, thank you so very much!!! At first I was so confused, I clicked on the formula in excel and it highlights the A1, A2, B1, B2 cells and I didn't think it worked when I dragged it over. I checked it against my manual entries and it proved it was the same results. Thanks for helping me understand Offset and how to tackle this sort of situation! Have a wonderful week.

 

[Eric W]

I'm glad it works for you! And I'm glad you bothered to figure out how it works too. Have a good day.