Dear all,

I've a table below:

Borrow Date Return Date Remarks
27 Jul 05
28 Jul 05
31 Jul 05

I want to set a function at cell C2 such that =IF(TODAY() - B2>=6, "Late
Return",""). However, if I fill in a date at "Return Date" column, then the
wording of "Late Return" at cell C2 will not be shown.

Please advise what are combination functions for the above two conditions at
cell C2.

Thanks in advance.