Hi
You will get "Late Return" only when the difference between today and
the return date is greater than or equal to 6 days.
Example
Borrow Date Return Date Remarks
27-Jun-05 22-Jun-05 Late Return
28-Jun-05
1-Jul-05
the formula in C2 is the same
=IF(TODAY() - B2>=6, "Late Return","")
Thanks
Karthik Bhat
Bangalore
Bookmarks