kamalmalek
01-29-2012, 11:54 AM
dear experts,
i have column "Locked" ,when user update his data in other column direct give me date/time he updated by this function:
=IF(ISTEXT(B2),TODAY(),"")
OR
=IF(ISTEXT(B2),NOW(),"")
the problem for me :any time openning the file: update me time and date "NOW"
What is the function to to keep the date/time of the user he updated "Not the date/time NOW!!!!!"
thanks in advance,
i have column "Locked" ,when user update his data in other column direct give me date/time he updated by this function:
=IF(ISTEXT(B2),TODAY(),"")
OR
=IF(ISTEXT(B2),NOW(),"")
the problem for me :any time openning the file: update me time and date "NOW"
What is the function to to keep the date/time of the user he updated "Not the date/time NOW!!!!!"
thanks in advance,