Wanting to link multiple IF/AND/OR functions into 1 formular

Hi All,  I have a tracker spreadsheet that upon entering dates into cells, there is a calendar section at the end where the dates populate into there in the forms of numbers - which are then conditi...