Thread: formula of Inserting a Date in a cell without updating the date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rabbi Moshe Hadad Rabbi Moshe Hadad is offline
external usenet poster
  
Posts: 1
Default formula of Inserting a Date in a cell without updating the date
I want to add a Date in a cell based on another cell,
For example:
=if(D2="","Empty",TODAY()),

But i don't want that "Today" will be update. It just need to stamp the Today date without keep updating.

Any idea?

Thank you
Reply With QuoteReply With Quote