MrExcel Publishing
Your One Stop for Excel Tips & Solutions

timing excel changes


Posted by rob on September 10, 2001 3:12 AM

Is there a way to format a spreadsheet to change
automatically with the computers clock? example:
If I want cell # A1 to remain blank until 12/12/01
then when the spreadsheet is opened on or after
that date, it would contain what ever number or word
i wanted.
Thanks,
rob


Posted by . on September 10, 2001 3:26 AM

=IF(NOW()>DATEVALUE("12/11/01"),"The time has come","")