Jun 07 2021 05:43 PM
Hello,
How could I make a msg box appear on the attached file when opening with a message box listing the Companies with dates 2 weeks from today for all columns that show [Amended] = "No"?
Kindly see attached file.
thank you
Jun 07 2021 07:29 PM
Hi,
I hope this is what you are meaning
=IF(C2="NO",IF((A2-TODAY())>=14,"More than two weeks","Less than two weeks"),"Amended")
You could use conditional formatting to highlight the rows that are two weeks away.
Jun 08 2021 05:20 AM