Using Dates

Occasional Visitor



Is there anyway to record a date that a cell was updated that does not change when the spreadsheet is reopened or calculated without using a macro ?

Trying to record a date an activity started to use as a reference for progress or elapsed days it took to complete a task.


Thanks in advance 

1 Reply
Only by using a circular reference, using a formula like this (suppose the formula is in cell B2):