View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lorianice lorianice is offline
external usenet poster
 
Posts: 1
Default 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?