Populate items across calendar based on base dates

Hello Gurus,

My issue is that I have items/products coming in and leaving my business based on set dates:

Check-in = day I receive
Check-out = day I ship them out
I have a month by month sheet in excel and I want to, by entering my check-in and check-out dates, that the amount of items populate automatically in my calendar (on same sheet) to show which days I am holding which item in my factory (check out dates does not count as they are leaving).

Is that possible?
I attach a screenshot and excel file

Thank you in advance very much

Hi,

For your uploaded sample, formula in F3, copied down and across to AJ4:

Formula:

Please Login or Register  to view this content.

See attached.

Jtakw, Thanks a million, this is exactly what I wanted!
Much appreciated

You're welcome, thanks for the rep.