A possible solution in edited workbook.
Added a calendar table and a calculated column into 1st table.
Btw, having a table you add a new column per week is a waste and after some time will be cumbersome! Why not design a report sheet, where you select a week (you can use data validation list), and a table for this week is filled (list of active employees in column A, list of active streams at top, and percents in table, plus additional column for person total).
|