Date update by a day but only when a box is ticked
I have a sheet which has a deadline on it. This deadline may be extended for a variety of reasons (unable to get parts, Waiting for a return email etc) Is there a way to have a check box that, when ticked, It'll add a day to the deadline automatically as it passes. At first, I thought this would be possible via automation but struggling to figure it out.
Thanks in advance for any help given.