sumproduct adding date to time range only works for same date

Hello John

Thank you for your help. It got me at bit further, but not all the way.
Now the first two due dates are correct.
I believe your appoach is the right one. I may just have to add additional "if" statements.

I'm attaching my workbook again, now with my expected results.