Saving date created with =Today()?

Posted to microsoft.public.excel.programming

BrianG[_3_] BrianG[_3_] is offline

external usenet poster

Posts: 20

Saving date created with =Today()?

I have a sheet where I use =Today() to fill in the date field when the
sheet is created. When the sheet is saved then reopened at some
future time the date field gets changed to the current date. How do I
automatically fill in the date cell when the sheet is first created
and maintain that same date when the sheet is opened for editing at a
future time?

--
BrianG

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
Saving TODAY function to keep the date accurate. (when it was done)	donuts	Excel Worksheet Functions	2	September 7th 09 08:46 PM
IF TODAY equals date in cell A10, or if TODAY is beyond that date	SoupNazi	Excel Worksheet Functions	4	April 23rd 07 01:14 AM
Saving MSForm.Control (s) created at Runtime?	Post Tenebras Lux	Excel Programming	1	August 16th 06 07:31 AM
Saving a file to have the filename of the dated it was created	Dave[_65_]	Excel Programming	1	May 17th 06 10:42 AM
FILES CREATED AUTOMATICALLY WHILE SAVING	Venoy Varghese P	Excel Discussion (Misc queries)	0	March 30th 05 04:01 PM

All times are GMT +1. The time now is 04:12 AM.

Menu

About Us