Insert new date once.
 

=today() puts the current date in the spreadsheet and changes it to the
current day when open.

Lets say that you have a spreadsheet that you re-use for clients (Save as to
keep the data for the client). When you open this spreadsheet you want
todays date going in, but not to change again.

I know a one time date insertion can be done, but that requires some clicks.
Is there a call (Like today()) that can do this?
---------
According to your description, my understanding of this issue is: when you
use =today() to put the current date in a cell, the date is updated next
time you open the workbook again.

If I have misunderstood your concern, please feel free to let me know.

As you noticed, The TODAY() function changes only when the worksheet is
calculated. The date and time used are taken from the computer's system
clock. When you reopen the workbook, the function is recalculated.

There is no such built-in function to realize your goal. However, based on
my knowledge, the goal can be achieved by programming (VBA). Please kindly
understand that development related issues are out of our support ability.
You can submit your question to MSDN newsgroup as they are best suited to
help you with the dev-related issues. You can reach MSDN newsgroup by
visiting the following link:

MSDN newsgroups
http://msdn.microsoft.com/newsgroups/default.asp

Insert new date once.
 

sub putdate()
range("a1")=date
end sub

--
Don Guillett
SalesAid Software

"Eric Vogel" wrote in message
...
=today() puts the current date in the spreadsheet and changes it to the
current day when open.

Lets say that you have a spreadsheet that you re-use for clients (Save as
to
keep the data for the client). When you open this spreadsheet you want
todays date going in, but not to change again.

I know a one time date insertion can be done, but that requires some
clicks.
Is there a call (Like today()) that can do this?
---------
According to your description, my understanding of this issue is: when you
use =today() to put the current date in a cell, the date is updated next
time you open the workbook again.

If I have misunderstood your concern, please feel free to let me know.

As you noticed, The TODAY() function changes only when the worksheet is
calculated. The date and time used are taken from the computer's system
clock. When you reopen the workbook, the function is recalculated.

There is no such built-in function to realize your goal. However, based on
my knowledge, the goal can be achieved by programming (VBA). Please kindly
understand that development related issues are out of our support ability.
You can submit your question to MSDN newsgroup as they are best suited to
help you with the dev-related issues. You can reach MSDN newsgroup by
visiting the following link:

MSDN newsgroups
http://msdn.microsoft.com/newsgroups/default.asp