Hi, I'm totally need some help in my excel..
Will someone with a kindly heart and bright idea help me here, please..

I have range of data, but I need to know how to classify it to each period depend on how long the item being rented (for each item)..
It is really a difficult task for me to do it automatically (Amateur me)..

Here's the sample Workbook : Boook.xlsx


I hope it will be enough to help you helping me out..
If it isn't clear enough, don't be hesitate to ask ok..

Thank you for your attentions..!
I'll be waiting for the helps..