Can I update a date formula only if checkbox changes?

  • Thread starter Thread starter lorianice
  • Start date Start date
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
Workday Formula to include date 0
Change formulas in a column based on a selection. 3
Excel Dragging countif formula with changing criteria 3
How do I subtract todays date from range of dates 1
Formula for Dates and CF Colour then convert to Text 3
Excel Message box with days of month & date. 1
Searching the formula (not the value) for a text string 1

Back
Top