• 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.

How to stop now() function from constant updates

Pasadu

Member
Dear Sir, In cell A2, I have this formula: IF(A1<>"",Now(),""). However, I want the situation whereby once the condition is true and the now() works, it should not update itself again. Once A2 works for the first time, it should not update itself again. Thank You.
 

Marc L

Excel Ninja
Hi,​
so you should not to use this formula and replace it with an UDF or a worksheet event but as it depends on how the cell A1 is updated …​
 

Hui

Excel Ninja
Staff member
Pasadu

Luckily for you I have been involved here since 2008

Because in January 2009, I remembered a post about Timestamps
Well I didn't remember the date, but I remembered the post


The post discusses a technique for using formulae with the Today() and Now() functions for setting date/time stamps that don't update, no VBA required

Enjoy
 
Top