#1
|
|||
|
|||
How do I lock in a Date in a cell?
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?
|
#2
|
||||
|
||||
impossible
Its not possible to lock the date from getting updated to the today's date.
it can be possible by creating a macro, but u will have to run the macro each and everytime when the data had been feed to the particular coloumn. |
#3
|
|||
|
|||
Couldn't you start IF statement to first check if the destination field is null? If it is apply the date, if it's not leave it alone.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
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 |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |