Convert General Format to Date, Nested IF Function, If Yes then highlight row

Sample Workbook.xlsx

Of course I have attached it with this post. I have included the raw data in tab raw and shown the manual completion in the second tab. I have not filled in all of the cells as they are not needed, however on my real spreadsheet these there is data present in the majority of these cells. Also I was unable to input the dates in column AD as general format so I have input them as text.
Many thanks