Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Insert Static Date when another cell is changed. Insert Static Date when another cell is changed.
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2017, 09:57 AM
evansrj evansrj is offline Insert Static Date when another cell is changed. Windows 7 64bit Insert Static Date when another cell is changed. Office 2013
Novice
Insert Static Date when another cell is changed. 		 
Join Date: Feb 2017
Posts: 2
evansrj is on a distinguished road
Default Insert Static Date when another cell is changed.

Good Morning. I am needing some help with inserting a static date. I have my sheet setup where Column C is a pulldown menu for cells C5-C99 with the options of Not Started, In Progress, and Completed. When the cell changes to completed I want Column F to populate the static date in the same row.

Any help would be appreciated.

Thanks
Reply With Quote
  #2  
Old 02-03-2017, 11:57 AM
xor xor is offline Insert Static Date when another cell is changed. Windows 10 Insert Static Date when another cell is changed. Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe like the attached.
Attached Files
File Type: xlsm Timestamp.xlsm (18.7 KB, 9 views)
Reply With Quote
  #3  
Old 02-03-2017, 11:59 AM
evansrj evansrj is offline Insert Static Date when another cell is changed. Windows 7 64bit Insert Static Date when another cell is changed. Office 2013
Novice
Insert Static Date when another cell is changed. 		 
Join Date: Feb 2017
Posts: 2
evansrj is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
Maybe like the attached.
Yes... can it be set up so that if the status is changed back to Not Started or In Progress that the date disappears? I know it seems trivial but it would be very helpful.

Thanks.
Reply With Quote
  #4  
Old 02-03-2017, 12:36 PM
xor xor is offline Insert Static Date when another cell is changed. Windows 10 Insert Static Date when another cell is changed. Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe like the attached.
Attached Files
File Type: xlsm Timestamp_2.xlsm (20.1 KB, 9 views)
Last edited by xor; 02-04-2017 at 01:17 AM.
Reply With Quote
  #5  
Old 02-03-2017, 11:48 PM
xor xor is offline Insert Static Date when another cell is changed. Windows 10 Insert Static Date when another cell is changed. Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Has been deleted.
Reply With Quote
  #6  
Old 02-04-2017, 02:00 AM
xor xor is offline Insert Static Date when another cell is changed. Windows 10 Insert Static Date when another cell is changed. Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Please forget all about #4 and #5 (my confusion).

The code in the attached file (slightly adjusted) is from:

http://www.mcgimpsey.com/excel/timestamp.html adjusted a bit
Attached Files
File Type: xlsm Timestamp_3.xlsm (19.5 KB, 12 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Static Date when another cell is changed. Need help with using traffic lights in one cell based on date value in a different cell wmedjaxnjr Excel 1 04-09-2016 04:22 PM
calculate date if date entered in cell, do nothing if blank ConfuddledOne Excel 3 11-07-2014 09:37 AM
Insert Static Date when another cell is changed. Counting Number of Months from a static date bremen22 Excel 4 11-25-2013 11:57 AM
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 PM.

Contact Us - Privacy Statement - Top

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