Divide dated column values every week

[harmonvi]

I need to divide weekly productivity per employee, by weekly hours per employee, repeating every week for the year. I need to keep every week's data so that I can track historical data.

Is there a way I can set this up to do it automatically or do I need to manually do it for every week? 

Thanks! 

[mahoneypat]

This can be fully automated.  If you share example data, a specific solution can be provided.

Regards,

Pat

[harmonvi]

Hours This image shows the employee hours worked each week

Productivity

This image shows the employee productivity per week

The top image shows the number of hours worked in a weeks time frame. The lower image shows the employees productivity per week. I currenly have been doing the manual calculation every week -

7/4/2020 Avg Daily Productivity = Hours[7/4/2020] / (Producitvity [7/4/2020] / 8).

 I divide by 8 to get the daily instead of weekly average. This is of course combined with a lookup between employee names to pull the correct value.