View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Take a look at

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


In article ,
JDP wrote:

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.