How do I run an Excel function only once?
 

What I want to do is have Excel calculate the current date a user is updating
a spreadsheet and show that date in a cell. They would then be able to come
back the next day, enter information, and a cell would display the current
date again, while still displaying the date that the spreadsheet was last
updated the previous day.

Basically, I can use the NOW or TODAY functions to calculate the current
date, but I can't get them to run only once then die after it was run.

I will try to look back here for answers but if you have an answer, if you
also wouldn't mind cutting and pasting your resonse in an email to
. Thanks very much.

Hi
you need VBA. see:
http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Viekn" schrieb im Newsbeitrag
...
What I want to do is have Excel calculate the current date a user is
updating
a spreadsheet and show that date in a cell. They would then be able
to come
back the next day, enter information, and a cell would display the
current
date again, while still displaying the date that the spreadsheet was
last
updated the previous day.

Basically, I can use the NOW or TODAY functions to calculate the
current
date, but I can't get them to run only once then die after it was
run.

I will try to look back here for answers but if you have an answer,
if you
also wouldn't mind cutting and pasting your resonse in an email to
. Thanks very much.

a very simple way of date stamping is ctrl+; and for time ctrl+shift+:
or with a macro
range("b22")=date

--
Don Guillett
SalesAid Software

"Viekn" wrote in message
...
What I want to do is have Excel calculate the current date a user is
updating
a spreadsheet and show that date in a cell. They would then be able to
come
back the next day, enter information, and a cell would display the current
date again, while still displaying the date that the spreadsheet was last
updated the previous day.

Basically, I can use the NOW or TODAY functions to calculate the current
date, but I can't get them to run only once then die after it was run.

I will try to look back here for answers but if you have an answer, if you
also wouldn't mind cutting and pasting your resonse in an email to
. Thanks very much.