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.
Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate...
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