Filter with time window (Array function?)

Hello,

is it possible to summarize a table with time windows? Assumption: There are different time windows of 5 days for each product when sales are happening (otherwise there are a bigger gaps than 5 days between sales).
Is it possible to filter/summarize this time windows with an excel array formula?

Example:
Example.xlsx


Thank you!

Best wishes
Tim

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.