Thursday, January 5, 2012

yogi_Save The Date A Cell Was Changed

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user ikekn said:
No recalculation of today(). Is that possible?
I would like to save the date that a cel was changed.
This can easily be done with the function today().
However, when someone causes a recalculation of the sheet the date will be changed.
My question: is it possible to save the date of today in a cell, without recalculation of the value at a later stage?
----------------------------------------------------
following is a solution to the problem: