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).

Attached Files

resource_utilization.xlsx (494.6 KB, 12 views)

thanks for the reply, that second option you mentioned sounds interesting, what should I research to work on that solution?

in the meantime I will look at the spreadsheet you uploaded.

I had some idle 30 minutes, so here is an example of report.