Look he
http://www.mcgimpsey.com/excel/timestamp.html
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"p11p00" wrote in message
...
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.