Try...

=IF(COUNTIF(A3:A30,"<"&TODAY()-7),TRUE,FALSE)

Hope this helps!

In article .com,
"oatmeal" wrote:

Yes that does work to an extent, thank you. The trouble is that is only
for one cell. I tried modifying it to:

=IF(A3:A30<(TODAY()-7),TRUE,FALSE)

or

=IF((A3:A30)<(TODAY()-7),TRUE,FALSE)

but neither of those work. I need it to check the entire column, and if
one of the dates is less than a week old, spit out true. It seems to be
adding them together or something.

-Steven