Thread: Fixed date with IF-function (or any other ideas?)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
p11p00 p11p00 is offline
external usenet poster
  
Posts: 4
Default 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.
Reply With QuoteReply With Quote