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

Thanks for your time.

However, I feel that this is going to be beyond me!

The formula that I gave as an example, is copied down to
row 100, so I am not sure what you are trying to tell me!

George Gee



*JE McGimpsey* has posted this message:

Take a look at

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
"George Gee" wrote:

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?