Fixed date with IF-function (or any other ideas?)

P

p11p00

Is it possible to add a fixed date automatically with if-function.

I want to add a date to a neighboring cell when it is not empty – meaning
date is added automatically to A1, when someone is writing to neighboring
cell A2. With “ IF(D3="";"";(TODAY()))†-function returns always the current
date, not the date of writing.
 
Top