Set Date Range within a defined range, not to start before first date defined

T&E.xlsx
The attached document is a timeline that lists responsibilities that need to be completed within a specific date range, Meeting Turnover Date and Meeting Start Date. The dates inserted now are default dates with a 100 day planning window. What is the formual if the window of time is less than 100 days? The range must fall within the Meeting Turnover Date and Meeting Start Date

The date in column F needs to be no later than the Meeting Start Date (for example April 6, 2012). Currently there are items that have a due date before April 6, 2012. Often meetings turn over in less than 100 days so the date in column F needs to be withig the two date range. Does that make sense? Thanks.

Unfortunately, when I placed =IF($D$3+E8>$D$2,$D$2,$D$3+E8)in cell F8 to F69, the dates did not populate correctly. If I remove the value in column E, the date in column F will correct to the MEETING TURN OVER date but I would have to remove all the values in column E and that would make every responsibility have the same due date (MEETING TURN OVER DATE). I need the responsibilities that are set before the MEETING TURN OVER date (April 6, i.e., 61 days from the event) to be the MEETING TURN OVER date then any responsibilities due after the MEETING TURN OVER (55 days to event, 25 days to event, etc…) to continue with down the schedule within the appropriate timeframe. Do you have additional thoughts?

Hello,
Removing the "-" and it does not work. I put in the correct dates in column F. If the meeting starts on June 6 and the meeting was turned over for planning on April 6, 61 days are left for planning. see attachment. You will see the some dates in Column F are before the April 6 turn over date (I marked in red). I need any dates that fall before the turnover date (April 6) to default to the turnover day and any days within the range follow column E predetermined dates. Each meeting turn over period could be different. 55days planning, 30 days planning, 100 days planning, etc...

Thank you for your thoughts.

I removed the formula in column F. There were only formula's in the red area, sorry I missed that. I have now entered the dates that would correspond with column E but the dates in red are before the turn over date of April 7th. I would prefer the dates that fall before the turn over date to default to the turn over date. I understand the theory on how to accomplish that for this specific turn over date/meeting date but if I was to change either turnover or meeting date, currently, column F dates would not change.