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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto set time(now) if criteria=true with no later change 1
Help with a formmula change in a "flag" parameter! 19
Creating a Report with Mulitple Headers 2
How do I make the now() static and not change with calculation? 2
Problems with Date() on forms - Help Please 5
Parameter Values for Criteria Not Set? 10
Problem with date criteria in Query 2
change =NOW() to permanent date string 4

Top