Post time when cell changes, or leave it the same if not blank

[Tipsey]

Hello, I would like to make a cell (E6) change to denote the time that (D6) became not blank, but I do not want that to change afterwards.

=IF(D6<>"",IF(E6="",NOW(),E6),"")

Is there a way of doing this that avoids the circular reference?

 

[Joe4]

The most common to do this is to use VBA (if you search on "Excel VBA Time Stamp", you will find literally hundreds, if not thousands, of threads and articles showing you how to do this).

If you want to do it without VBA, then there are ways you can do it with using iterative calculations. I have not used these myself (I am a big fan of VBA), but here is an article on it with instructions:

How to Insert Excel Timestamp When Cell Changes Without VBA (3 Ways)

This article describes 3 easy ways to insert excel timestamp when cell changes without vba. Use these methods to solve your problems easily.

www.exceldemy.com