Date Breakdown into Columns

[Justinian]

I run a report every morning for moving dates. For example, today's report is 6/2-6/5. I want Excel to recognize each unique date and place those dates starting in E11. So for today, I want Excel to put "2nd" in E11, "3rd" in E12, "4th" in E13, and "15th" in E14. Tomorrow's report will be 6/3-6/9 so there will not always be just four (4) dates.

How do I get Excel to do this?

 

[Justinian]

@jasonb75 I cannot use pivot because all the unit codes and dates have to be visible, not just the data in E12:G18.

@Toadstool Your formula works perfectly.

Thank you both for your help and most importantly, your patience!