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","")
