date formula not right

  • Thread starter Thread starter Bob Bob
  • Start date Start date
B

Bob Bob

=IF(OR(ISBLANK(A1),A1=0),"",NOW())
I am using this formula in B1 to record the date when cell A1 has been
updated. Problem is the date is always updating to the current date. How can
I change it so it show when the cell was updated?

Thanks
 
=NOW() or =TODAY() etc will always update everytime the worksheet
calculates.
There is as far as I know no formula which will return a fixed date, Ctrl
and : pressed together will give the date which will not change.You can use
VB code to hard copy the date when you update A1, or you can copy > paste
special > values to lose the formula and leave only the result in A1.
If you want to use VB code there are lots of examples on these groups which
can be Googled.
Regards,
Alan.
 
Back
Top