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

CarinaS

New Member
Joined
Oct 17, 2022
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
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:

1665987502273.png


=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?
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
I think "not equal to" operator is what you are looking for:
Excel Formula:
=IF(AND(K9<>"";(I9+30)<L9);"Follow Up";"")
 
Upvote 0
JUst change the commas to semi-colons to match your local settings.

Book1
IJKLM
1Date of ExchangeExchange etcEx Comm ReceivedTodayFollow up
22022/01/312022/10/31 
32022/02/012022/10/17Follow Up
42022/10/312022/10/17 
51900/02/012022/10/17Follow Up
62022/02/042022/10/17Follow Up
Sheet3
Cell Formulas
RangeFormula
M2:M6M2=IF(AND(I2<>"",K2="",(I2+30)<L2),"Follow Up","")
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,334
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top