Can I update a date formula only if checkbox changes?
 

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?

Can I update a date formula only if checkbox changes?
 

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?