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

Checkbox and Satic Date 1
Date function 11
Workday Formula to include date 0
Rounding date field up to next first of month, with existing formu 5
Excel Dragging countif formula with changing criteria 3
set checkbox to enter date when checked and NOT recalculate 4
Formula for Dates and CF Colour then convert to Text 3
Inserting current date 8

Top