Try:

=MAX(A3:A30)TODAY()-7

You don't need an IF() function when all you're looking for is a TRUE
or FALSE answer

This will give a TRUE result if the most recent date in your range is
less than 7 days old and a FALSE result otherwise


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=471990