| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| adding value only if criteria is true | Excel Worksheet Functions | |||
| Use IF to change value in a different cell when TRUE (or FALSE)? | Excel Discussion (Misc queries) | |||
| Countif( 2 criteria = true ?) | Excel Discussion (Misc queries) | |||
| how do i get a TRUE value in a formula to change the color of the. | Excel Worksheet Functions | |||
Hybrid Mode
