In Excel (ideally without VBA), I need to do the following:

• Using an input of start and end dates of holidays of employees (each single holiday has its own row –> multiple rows per employee)
• transform those start and end dates per employee in a way to count holiday-days per calendar week only considering workdays (mo-fr/sa)

Can someone help with an easy fix that I am not seeing at the moment?