Current date against a ticked checkbox.

Piotr Pulawski

Hi,

 

I'm trying to come up with a formula that will populate a given cell with the current date if and when a certain checkbox has been ticked. Please note, this date must be fixed, i. e. it must NOT change as the days go by. Is this possible at all?

 

I know this is completely wrong, but just to illustrate better what I mean ("Done1" because the checkbox is in a column called "Done").

 

=IF(Done14, 1, "whatever would insert the date").

 

Further do this, there will be additional cells which are supposed to take that fixed date discussed above, add, say, 7 days to it and display the result.

 

Thank you kindly in advance for any and all replies.

Kennedy Stomps

Hi Piotr-- Great question! We don't currently offer a function that would capture the date when the function was inserted into a cell (the TODAY() function captures the current date, so will change from day to day). This is a good feature request, though, and I will add your vote for it to our enhancement request list. Thanks for the input!