Thread: Date formula
View Single Post
  #1   Report Post  
George Gee
 
Posts: n/a
Default Date formula

Hi All

I would like to put today's date into a cell by entering data into another
cell, the following is what I am using now:

= IF(B3="","",TODAY())

If I open the worksheet tomorrow, then the date will change,
how do I get the date to not change?

Thanks

George Gee
--