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

Myrna Larson

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date updates from worksheet to chart & changes date to a date series! Help!!	Jayjg	Charts and Charting in Excel	2	January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version	dlg1967	Excel Discussion (Misc queries)	4	January 19th 05 03:51 PM
How do I stop today() from updating date on saved spreadsheets?	lionmark	Excel Discussion (Misc queries)	2	January 4th 05 01:03 AM
Auto date changing in Excel is maddening	brhicks	Charts and Charting in Excel	3	December 16th 04 02:54 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM

All times are GMT +1. The time now is 03:31 PM.

Menu

About Us