Forum Discussion

Copper Contributor

Dec 05, 2022

Date of Last Modified for a Cell

Good day, all. I am inquiring if there is an excel function that would give me a date (and time) that an individual cell was last modified. For example: cell A2 has an entry of $2.55 and I'd lik...

excel

Formulas and Functions

Macros and VBA

office 365

bb5931

Copper Contributor

Jan 31, 2025

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!

HansVogelaar
MVP
Jan 31, 2025
Like this. Don't forget to enable Iterative Calculation, otherwise it won't work.

=IF(OR(J2:L2<>""), IF(M2<>"", M2, NOW()), "")
- bb5931
  Copper Contributor
  Feb 03, 2025
  Thanks for your reply HansVogelaar.
  
  This seems to only work if the modification is blank to non-blank? (Iterative Calculation is enabled)
  - vp821
    Copper Contributor
    Jun 28, 2025
    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?