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