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

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.

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

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.

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

Thank you very much, it worked:)

Best regards,

Elina

"Niek Otten" kirjoitti:

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.