Unfortunately, if you simply use the "Today" command, it will return the
date of the current day you are looking at the sheet. The IF functions
should be able to take care of it if you use circular references, but
I'd have to sit and think for a while on how to do it.


--
redstang423
------------------------------------------------------------------------
redstang423's Profile: http://www.excelforum.com/member.php...o&userid=37333
View this thread: http://www.excelforum.com/showthread...hreadid=570319