Using Dates

Copper Contributor

Hi

 

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):
=IF(A2="",TODAY(),B2)