Yes, that is correct. TODAY() and NOW() functions are volatile. They
will update when any formula in the entire workbook recalculates
regardless of cell references, or when the workbook is opened or saved.
However, they remain static until excel calculates.
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread:
http://www.excelforum.com/showthread...hreadid=555043