Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-17-2011, 09:32 AM
GatorFan1 GatorFan1 is offline How do I lock in a Date in a cell? Windows 7 32bit How do I lock in a Date in a cell? Office 2007
Novice
How do I lock in a Date in a cell?
 
Join Date: Aug 2011
Posts: 1
GatorFan1 is on a distinguished road
Default 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?
Reply With Quote
 



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
How do I lock in a Date in a cell? 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 04:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft