Dynamic Date Comparison and Cell Population

I am stuck on how to make this work and I could really use some help.  This file will be on a server for others to access as well.

 

I have a list of products with serial numbers. Each product has a scheduled start and end date.

 

I have created a calendar with the days of the month.  I need each day on the calendar to show which products will be in progress for that day.  I don't anticipate more than 12 products to be in progress for any one day.

 

The cells for each day need to be dynamic.  If I change the scheduled start/end date on the list, I need the calendar to adjust automatically.

 

I created a mock up to show what I mean.  The list will be the entered data, and the calendar cells will be the dynamic auto fill cells.

 

Thank you so much in advance.