Assign dates as late as possible without duplicates

Hello,

I'm looking for a formula that will populate Column C below, using the list from Column E:

Screenshot 2024-08-09 123650.png

Column C must contain dates that:
Must be from Column E
Does not repeat (no duplicates)
Occurs prior to the date from Column B
Occur as late as possible, given the constraints above (major challenge is to produce as late as possible)

I have tried the RANK function, even assigning different duplicates to no avail.

Any thoughts?