Help with formula to stop counting days when a value is entered into another cell

This is my first time to ask a question so hopefully I am explaining my question correctly.   I have an IF statement that counts down days based on a start date (L) and target date (BE) that is dep...