View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
starguy starguy is offline
external usenet poster
 
Posts: 1
Default =TODAY() function to fix the date


I want to fix the date in a cell with a formula whenever other cell is
populated.
e.g when cell B1 is populated, cell A1 should show the date of that day
and that should not change later on.
I have seen some posts with the same question but with no answer.
any guru on this..??


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=561042