OFFSET formula not working when dragged

Hello all,

I have an Excel sheet which contains a basic formula to divide a month total by 7 (to get a daily amount) and then it multiplies this by the number of days in the month.

On the spreadsheet there is a blank column between each month and so dragging the formula does not work.

I've created an OFFSET formula which takes into account the column in between each figure, but when I drag the formula it doesn't increase the number of columns from the reference cell. It should increase the number of columns by 2 each time.

I hope this makes sense - I've attached a sample sheet which contains the data and formulas.

Can anyone point me in the right direction?

Thanks in advance