Hi
I'd like to write a formula that returns a "Follow Up" if today's date is 30 days later than the registration date of a property.
I have managed to get it somewhat right, but need to add on one more condition:
=IF(AND(K9="";(I9+30)<L9);"Follow Up";"")
I now need to add another condition where if Date of Exchange (Column I) is empty, then it also needs to return "".
Can someone please help me?
I'd like to write a formula that returns a "Follow Up" if today's date is 30 days later than the registration date of a property.
I have managed to get it somewhat right, but need to add on one more condition:
=IF(AND(K9="";(I9+30)<L9);"Follow Up";"")
I now need to add another condition where if Date of Exchange (Column I) is empty, then it also needs to return "".
Can someone please help me?