![]() |
#1
|
|||
|
|||
![]()
i have a spreasheet to track completion status on Jobs. i am using the following formula to return a value based on employee input in the previous cell as "started" or "complete": =IF(B2="complete",TODAY(),IF(B2="started","In Process","")) my problem is each day the completion date changes. is there another function to lock in the date that the data was entered?
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lock a Slide | Pemberton | PowerPoint | 0 | 07-18-2010 04:43 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
How Ms Word Lock | memo85 | Word | 0 | 08-16-2009 07:23 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
![]() |
promark | Outlook | 1 | 12-23-2005 07:21 AM |