Unticked boxes to trigger reminder dates

pea.ccu49236

In my project sheet, I have a Task Complete tick box. 

I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date. 

Is this possible?

L_123

=IF([Task Complete]1 = 0, TODAY(), "")

 

Will post todays date if the checkbox is empty. Change today() to whatever equation you want in that formula.