MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Dates constantly changing

Posted by Jayne on July 24, 2001 1:27 AM

This is probably a simple solution, but one I just can't figure out. I need a formula that will make a certain cell, say F8, display today's date, but once today is over, I want it to stay the same date. The problem I'm having with this is, the date will change in the cell as my system clock rolls past midnight. Once that date is in the cell, I want it to stay there an not change. Any ideas?

Posted by Aladin Akyurek on July 24, 2001 2:25 AM

Hit CONTROL+; to create a sticky date.