Recording the date a cell was changed

[Slinky]

Hi Guys
I am just wondering if there is an easy way of recording the date in say cell A2 when the value in cell A1 has been changed. Then in cell A3 calculate the number of days since the value in cell A1 was changed.
Thanks in advance.

[Colin Legg]

Hi,

In cell A3 put in this formula and format the cell as General:
=IF(ISNUMBER(A2),TODAY()-A2,"")

Then right click on the worksheet's tab > View code, paste in the below code:

Please Login or Register  to view this content.

[Slinky]

I have tried it but how do I check if it works?
Would this also work for minutes and seconds?

[Slinky]

I have been playing with this have now got my head around it.
Works perfectly.
To take it one step further, how would I check all cells in row N for example.

Here is the code I am using now.

Please Login or Register  to view this content.

[Slinky]

Sorry should have been row E for example.

[Colin Legg]

Hi,

I have been playing with this have now got my head around it.
Works perfectly.

Good stuff. You can check if a cell was changed in column E like this:

Please Login or Register  to view this content.

[Slinky]

Thanks for that Colin
Works great