I’m very formula challenged…

I run a halfway house and I’m working on automation of the rule violations sheets. For each violation, there is the first consequence with a date duration and a second consequence with a date duration. Example: Late for Cewfew: 1st offense no passes for 14 days. 2nd offense no passes for 30 days.

I have the duration formulas figured out, but I need to link them to another table only showing the current duration end date. I’m wanting to create a Current Offense End Date.

Basically, If the 1st consequence end date is empty then I need it to enter the 2nd consequence end date.

I hope that makes sense. I just have not been able to figure it out.

Thanks in advance for any help

Kathy