Loop between date and make a sum depending condition

Hello,
I have the next problem: I have a 2 sheet book with data:
sheet1 - dates in columns and products in rows, as there mus be working and now working days;
sheet2 - start and end date of product use for each person (in rows), where depending them and index to make a sum.
I attach a screenshot that shows example.
I will be very gratefull if I get answer how to make that.
Thank you in beforehand.
Yours, Plamen

Could you attached this sample file, please.
Check yellow banner at the top of page.

Hello patronaja and Welcome to Excel Forum.
I had to change some of the layout on Sheet1 to make the following array entered formula** work:

Formula:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Test the formula by adding the date 10/4/2020 into cell J4 on Sheet1.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.