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.