auto set time(now) if criteria=true with no later change
 

I am using excel to manage a continues progress report on a data base of
users. The report includes set of stages that the users are going through.
Each time a define criteria set on (true), the user is moving from one stage
to the next.

I have a cell in which I mark the entry day (the day the user enter the new
stage). Once the date was set, it should be constant and should not change in
the future, even if the criteria was change.

I am looking for a automated way to set the date (today) but once set, stay
as a constant.

Using €œ =IF(G7+H7+I7 = 1,TODAY(),"") €� will set the date but once I change
the values in G7/H7/I7 the date is being re-set.

Rafi

auto set time(now) if criteria=true with no later change
 

see

http://www.mcgimpsey.com/excel/timestamp.html

In article ,
Rafi Benami wrote:

I am using excel to manage a continues progress report on a data base of
users. The report includes set of stages that the users are going through.
Each time a define criteria set on (true), the user is moving from one stage
to the next.

I have a cell in which I mark the entry day (the day the user enter the new
stage). Once the date was set, it should be constant and should not change in
the future, even if the criteria was change.

I am looking for a automated way to set the date (today) but once set, stay
as a constant.

Using €œ =IF(G7+H7+I7 = 1,TODAY(),"") €� will set the date but once I change
the values in G7/H7/I7 the date is being re-set.

Rafi