Hi all,

I am using office 2003; I am trying to fix up a automated time tracking system.

I like to find when the particular field is updated in the excel and update the same in the adjacent row. Let me give you a example

Field A5 will be filled as Yes / No I want the A6 to be filled with the date and time of the field A5 got updated

I tried with this formula: @ A6 I typed -= IF(ISBLANK(A5)=FALSE,NOW()," ")

but the problem is this when ever I save the excel the A6 is getting updated with the current time.

With regards
Pradeep