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.