If formula

How do I create a formula, such that if a cell with a checkbox is ticked, the previous cell containing the date of activity is erased and checkbox is empty again