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

Chaneyt

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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 11:32 PM.

About Us