How do you keep the date using =TODAY() from changing?
 

Is there a way of using the =TODAY() function and lock that date, so it
doesn't change if I were to open it on another day?

Hi
see http://www.mcgimpsey.com/excel/timestamp.html
Also Ctrl ; will automatically put today's date in the cell


"Chaneyt" wrote:

Is there a way of using the =TODAY() function and lock that date, so it
doesn't change if I were to open it on another day?

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

--
Regards
Frank Kabel
Frankfurt, Germany


Chaneyt wrote:
Is there a way of using the =TODAY() function and lock that date, so
it doesn't change if I were to open it on another day?

Not with a formula, now. If you want to insert a static date, you can do it
fairly easily with the keyboard shortcut CTRL+;

On Fri, 29 Oct 2004 13:24:02 -0700, "Chaneyt"
wrote:

Is there a way of using the =TODAY() function and lock that date, so it
doesn't change if I were to open it on another day?