Thread: Inserting dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Corey
 
Posts: n/a
Default Inserting dates

Try this:
=IF(A11,NOW( ),0)

It will place the current date in B1.
Not sure if that is what you mean by 'Not Change'.

Corey....
"JDay" wrote in message
...
If anything appears in cell A1, I want the date to appear in cell B1 but
not
upate. I would like that date to remain the same and not change (update).