Formula Date field based on Conditions
I have a Formula Date Field titled Tentative Discharge Date and want it to update based on the conditions below
If Date of First Symptoms is NULL, Tentative Discharge Date is 10 days after Date COVID-19 Test Completed or if that is NULL, Tentative Discharge Date is 10 days after Placement Date
------------------------------
D
------------------------------
If Date of First Symptoms is NULL, Tentative Discharge Date is 10 days after Date COVID-19 Test Completed or if that is NULL, Tentative Discharge Date is 10 days after Placement Date
If [Entrance Reason] = "New Placement" or "Room Change", [Tentative Discharge Date] is;;;
If [Reason for Placement] = "Customer had contact with known positive", [Tentative Discharge Date] = 14 days after [Placement Date]
If [Reason for Placement] = " Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
If [Reason for Placement] = "customer is positive", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
If [Entrance Reason] = "!Customer returned after preclearance departure!", [Tentative Discharge Date] is 10 days after [Placement Date]
------------------------------
D
------------------------------