Help with date formulas

[Kathryn_Curtice]

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

[TheTimeSavingCo]

Hi @Kathryn_Curtice , could you include some screenshots of the automation and the table setups?

Once I know how your data is setup I’ll be able to provide some assistance; as it is now I don’t have enough to go on I’m afraid

[Kathryn_Curtice]

I figured it out thanks for your help