| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use date formula to update workbook in real time | Excel Worksheet Functions | |||
| How do I update a checkbox as true when another has been updated | Excel Worksheet Functions | |||
| How to auto update date contained in formula | New Users to Excel | |||
| formula to return date of most recent update | Excel Worksheet Functions | |||
| Update a formula based on date worksheet was saved | Excel Worksheet Functions | |||
Hybrid Mode
