Two Conditions Function

[Guest]

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.

 

[Karthik]

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

 

[Roger Govier]

Try
=IF(AND(B2="",TODAY()-A2>=6),"Late Return",IF(B2-A2>=6,"Late Return",""))