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

Chaneyt · Oct 29, 2004

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?

mzehr · Oct 29, 2004

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

Frank Kabel · Oct 29, 2004

Myrna Larson · Oct 29, 2004

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