Forum Discussion
Date of Last Modified for a Cell
Hi All,
Have the same question as the OP but for modification of a cell within a group, i.e. the last modified timestamp appears in say cell M2 if any of J2, K2 or L2 have been modified. Tried something with IFS function but can't get it to work.
Currently using the below formula for timestamp of any modification inc. non-blank to non-blank: =IF(L2<>"",IF(AND(M2<>"",CELL("col")<=6,CELL("col")>=1,CELL("row")=ROW(L2)),NOW(),IF(CELL("address")<>ADDRESS(ROW(L2),COLUMN(L2)),M2,NOW())),"")
Thanks for your help!
Like this. Don't forget to enable Iterative Calculation, otherwise it won't work.
=IF(OR(J2:L2<>""), IF(M2<>"", M2, NOW()), "")
Thanks for your reply HansVogelaar.
This seems to only work if the modification is blank to non-blank? (Iterative Calculation is enabled)
Thank you! It worked for me, EXCEPT: it only works when cell changes from empty cell to X, Y, Z but it does not work if the content of the cell changes from Y to Z. Do you know a way around that?
As mentioned before in this discussion: the proposed formula will only create a timestamp when the cell it refers to was empty, but is now filled by the user. The timestamp will remain unchanged when the value is changed.
If you want the timestamp to be updated each time the cell is edited, it requires VBA code, which will work in the desktop version of Excel for Windows and Mac.
If you want the date/time to change each time a cell in J2:L2 is edited, you do need VBA. A formula won't work,
