Look he
http://www.mcgimpsey.com/excel/timestamp.html
See the section: Using circular references and worksheet functions
--
Biff
Microsoft Excel MVP
"lorianice" wrote in message
...
I have a formula that inserts the current date when a checkbox is checked.
I
need that date to remain constant unless the checkbox changes. In other
words, I do not want the date to change the next day. The formula uses the
"TODAY()" function. Is there something else that I can use or some other
way
to do this?