View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jodi[_3_] Jodi[_3_] is offline
external usenet poster
 
Posts: 5
Default Now Date Formula

In cell A5 I have the following formula =IF(B5="","",NOW())
which allows me to enter something into cell B5 and then
the date fills in automatically. What I need is make it
so the date doesn't change in A5, when I go into the
spreadsheet again.