How to make a cell blank if another cell is changed?

[mryneuman]

i want to update the date of the latest CANS NY and the cell "✔" sould erase itself or change to "x"

[#2]

@mryneuman 

If date then hack, otherwise X.

Example in the inserted file.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@NikolinoDE I want when I change the date to a "new date" it should lose the check, 

The change in cell C2 should be the trigger to change or erase cell C3,

[#4]

or maybe if cell c2 is NOT same as the C2 of previous versions it should change to X

[#5]

Unfortunately, I can not follow the meaning of the matter.
Please add a worksheet (without sensitive data) and describe your project exactly on the basis of this file.

Thank you for your understanding and patience

NikolinoDE
I know I don't know anything (Socrates)

[#6]

@mryneuman 

The attached contains a code on Sheet1 Module for Sheet_Change and Sheet_SelectionChange Event.

Does this work for you?

[#7]

@Subodh_Tiwari_sktneerthank you all for trying to help me, I am going to explain my self again, I am sorry I guess I was unclear,

the CANS NY assessment is due every 6 month, then I have to upload the CANS NY assessment form to a site, 

every time I make a new CANS NY assessment I change the date, but the check that i uploaded the last one is still there, and I can forget to upload the CANS NY assessment form.

So this is what i want:

when i change the date for the last CANS NY assessment I want the check on the uploaded row to become a X and i will change it manually to a ✔ when I will upload the CANS NY assessment form