Share via

Using TODAY() to Date Stamp text changes

Jansen, Randolph (CCI-RapidScale) 0 Reputation points
2023-10-31T00:43:54.4666667+00:00

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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 26,606 Reputation points Microsoft Vendor
    2023-10-31T08:30:45.12+00:00

    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.

  2. Paul 0 Reputation points
    2024-12-19T16:54:26.84+00:00

    Have a look at very similar question at https://zcusa.951200.xyz/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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.