Help needed with automatic formula population

I'm wondering if someone may be able to help me with this...

I have made a sheet that will give me a daily capacity roll over flow and it works really well.
I originally made it for just six weeks but found It difficult to come up with a way to copy the formulas across due to the cell references so i had to do a lot of the work manually.
this obviously took a while with 46 columns x 46 rows.

i would somehow now like to extend this sheet to do a whole year but with 365 columns x 365 rows I would really like to know if anyone has any ideas on how to make this task easier than before.

i have attached an example of 2 weeks with data inputted for 1 week, thanks in advance for your help.

here is an example sheet