Formula Date field based on conditions

There seems to be an omission in your description. 
If the Entrance Reason isn't New Placement or customer changed room AND Date of first Symptoms is NOT NULL - what is the tentative discharge date.
Also is the are highlighted in orange intended to be dependent on the reason for placement (statement above it).
If the field "Entrance Reason" = New Placement or customer changed room

• If [Reason for Placement]="Customer had contact with known positive," [Tentative Discharge Date] is  [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 [Date of First Symptoms] is Null, [Tentative Discharge Date] is 10 days after [Date COVID-19 Test Completed] or if that is blank, [Tentative Discharge Date] is 10 days after the [Placement Date]
• If [Reason for Placement]="Customer is positive", Tentative Discharge Date is 10 days after Date of First Symptoms

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 the [Placement Date]

Is it possible to create a table with the tentative release date and the conditions which would cause that date, for example:
14 days after Placement: Customer contact with known positive
10 days after Placement: Customer showing symptoms and no date of first symptoms and no Covid test date
10 days after First Symptoms: Customer is Positive
...
Let me know if you can - happy to help..





------------------------------
Neil Schneider
------------------------------