Formula to return a 'Follow Up" if a date is past 30 days with multiple conditions

[CarinaS]

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?

 

[Legacy 143009]

I think "not equal to" operator is what you are looking for:

=IF(AND(K9<>"";(I9+30)<L9);"Follow Up";"")

 

[kevin9999]

JUst change the commas to semi-colons to match your local settings.

Book1
	I	J	K	L	M
1	Date of Exchange	Exchange etc	Ex Comm Received	Today	Follow up
2	2022/01/31		2022/10/31
3	2022/02/01			2022/10/17	Follow Up
4	2022/10/31			2022/10/17
5	1900/02/01			2022/10/17	Follow Up
6	2022/02/04			2022/10/17	Follow Up
Sheet3

Cell Formulas
Range	Formula
M2:M6	M2	=IF(AND(I2<>"",K2="",(I2+30)<L2),"Follow Up","")