Using TODAY() to Date Stamp text changes

Question

I love the formula, =IF(A2<>A2, "", TODAY()), to time stamp quantity changes in a cell.

However, does anyone know how to handle this for text? I want a date stamp every time text is changed in a cell (like updating notes, or product names, etc).

Because text isn't treated as "greater than" or "less than" it doesn't appear to work with this solution.

Answer 1

Have a look at very similar question at https://learn.microsoft.com/en-us/answers/questions/1136333/datestamps-in-excel-when-a-cell-value-changes the formula there works for showing dates of cell changes, you will need to add a comparison cell and iterative formulas to make it work. it's all explained in the solution,

P.S the formula you give above activates on the else part of if statement and will i believe update on every call of the today function and not only when the entry is changed in the referenced cell

Answer 2

Hi,

Did you mean if you change the text in the same cell, then you will get a time/date in another cell?

If the behaviors are all in the same cell, then the formula may not meet your needs and you need to use macros.

Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.