Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 11-28-2011, 03:30 AM
Nirik's Avatar
Nirik Nirik is offline How do I lock in a Date in a cell? Windows XP How do I lock in a Date in a cell? Office 2003
Smart Novice
 
Join Date: Dec 2010
Location: Mumbai, India
Posts: 24
Nirik is on a distinguished road
Default 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.
Reply With Quote
  #3  
Old 12-02-2011, 09:33 PM
MrCrum MrCrum is offline How do I lock in a Date in a cell? Windows Vista How do I lock in a Date in a cell? Office 2007
Novice
 
Join Date: Dec 2011
Location: Central NJ
Posts: 3
MrCrum is on a distinguished road
Default

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.
Reply With Quote
Reply

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
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 09:51 AM.


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