Can I update a date formula only if checkbox changes?

L

lorianice

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Display weeks from a Milestone 0
How to create bulleted to-do list using two styles? 5
Use TODAY() function as the criteria in a SUMIF formula 1
Autofill Date in Word 15.33 for Mac 0
IF AND Function Date Range Issues 6
Checkbox and Satic Date 1
Tracked changes by multiple people modified to one 0

Top