• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Timestamp - Change the timestamp in case someones modifies the cell

Charlie Day

New Member
I came across this post "https://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/" on chandoo. =IF(C3<>"",IF(B3="",NOW(),B3),"") is the formula Chandoo suggested and it works well except when you change the value in the cell (similar question was posted by one of the readers 'Oliver': "but I also would like to change the timestamp in case someones modifies the cell. Is that possible without VBA?"
Now this post was made on 2009 and I'm wondering if anyone was able to find a solution to this problem. Thanks
 
Back
Top