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


Bryan Hessey wrote:
Does

=IF(A1<(TODAY()-7),true,false)

work for what you need?



oatmeal Wrote:
I have a number of simple two column sheets, one column contains dates.
Basically each sheet is an employee, and the items list the date and
notes for any "one on one meetings" that I have with that employee. I
want to have a summary sheet that lets me know when the most recent
meeting was.

I think it would be ideal to check sheet1-5, if date is older than 1
week, output false or true.

I can't find any formula example on the net that uses dates as a
condition of true or false. Can anyone point me in the right direction?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=471990