I'm dumb here we go:

=IF(A1<TODAY(),TRUE,FALSE)

You have to make sure to specify true or false it is not automatically
returned.. i.e.
if(a1<today()) is not going to work.


--
sagan
------------------------------------------------------------------------
sagan's Profile: http://www.excelforum.com/member.php...o&userid=27438
View this thread: http://www.excelforum.com/showthread...hreadid=469507