How do I lock in a Date in a cell?

		Microsoft Office Forums > Microsoft Excel > Excel
How do I lock in a Date in a cell?

FAQ

Thread Tools

Display Modes

11-17-2011, 09:32 AM

GatorFan1

Windows 7 32bit How do I lock in a Date in a cell?

Office 2007

Novice

Join Date: Aug 2011

Posts: 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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:35 PM.