Just got it, i used a TODAY() function nested with an IF
function.
cant believe i didn't think of that straight away.
--
Aikisteve
------------------------------------------------------------------------
Aikisteve's Profile:
http://www.excelforum.com/member.php...o&userid=36111
View this thread:
http://www.excelforum.com/showthread...hreadid=570319