Good Morning,

Every month i get paid. If i do something different from my own job during the month i get paid average pay as opposed to regular basic pay. Average is worked out by taking total earning including everything for the previous 12 months, dividing it into weeks then dividing it again into days (currently 5 a week)

If i imagine A1:L1 contains my monthly gross figures, what calculation is required in M1 to show my daily average? ( i can do this bit without too many issues)

Bearing in mind "next month" it's monthly figure will be entered into an "inserted column" which will then become M1 so the calcs in M1 currently will become N1 and so on each and every month.( so, the calc needs to reflect B1:M1 The following month needs to reflect C1:N1 and so on).

The calculations in what is currently M1 and next month N1 and so on need still to count only the previous 12 month's figures.

I hope that makes sense and someone may be able to assist me with this problem as i can't make it work.

Finally, if there is a simpler way to lay this out rather than just keep getting longer and longer across the sheet then i would definately listen.

Thank you

Mike