Thread: if/then insert date but don't want automatic updates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
redleg redleg is offline
external usenet poster
  
Posts: 12
Default if/then insert date but don't want automatic updates
I have a spreadsheet tracking personnel actions. I tried the following
formula =IF(L2="","",TODAY()) but I do not want the date stamp to
automatically update when the spreadsheet opens. How can I write a simple
formula so that when the cell has text entered into it, the date will be
recorded in the adjacent cell as a static stamp? Thanks.
Reply With QuoteReply With Quote