Formula with many conditions required please

[Orangeanorak]

Grateful if a formula can be supplied for this one please. No VBA if possible
Column E deadline
If D5 = Emergency and the date in A5 is equals today insert text "In Progress" if = 1 day more insert text "Expires Today" if more than 1 day insert text "Expired"
If D5 = Urgent and the date in A5 is less than 3 days ahead insert text "In Progress" if = 3 days ahead insert text "About to Expire" if 4 days ahead insert text "Expires Today" if more than 4 days insert text "Expired"
If D5 = Routine and the date in A5 is less than 24 days ahead insert text "In Progress" if 24 to 27 days ahead insert text "About to Expire" if 28 days ahead insert text "Expires Today" if more than 28 days insert text "Expired"

Thank you --------- Mission Impossible ?????

 

[Orangeanorak]

As the formulas would Have to be in the Target Sheet (e.g. form 1, form 2, form3, etc.) and Not the Schedule Sheet, you will, unfortunately have to Manually enter those formula in each form/sheet.
You can probably get this done by VBA, but I'm not strong with VBA and unable to help using this method.

Thank you