Enter date or clear cell according to other cell's data

[bahadir70]

I have an excel sheet for my safety officers fill for daily reports. They are making mistakes while filling, so I want to make it more easy for them and for me as well.

As seen attached pictures, if R3 (condition) is "Open" if they put a date in "Q3" I want "Q3" will be cleared (only value-not format or conditional format)

and if they select "closed" at "R3" I want "Q3" will get the date on the form filled date. (but not like today() option, because today() option is updating the date when we open the form.

I did a data validation for R3 to select "Open" or "Closed"

Can anybody help me?

I am very new (just nothing )for VBA codes,

 

[bahadir70]

I'm glad to help you. Thanks for the feedback.

Can you please help me about the questions I asked please?

 

[DanteAmor]

Sorry I can't keep up with the help, but I'm not understanding what you need.
You could create a new thread.