yeah, my bad. I forgot that both NOW() and TODAY() update themselves
when the spreadsheet recalculates. Sorry about that.

Without doing it manually, a macro like Gord suggeted would be the only
way to get a static date.


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=536454