Excel formula to populate a cell with Yes/No depending on dates on other cells.

Dear Team, Pleas I need assistance in writing an excel formula to accomplish the following scenario. For an equipment sign in/out sheet, I want a cell to be populated with either a "Yes " or "No...