Message Box - 15 days prior to Date

Super Contributor



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


2 Replies


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.



Hi Stonekiwi, thank you for the response. I sould have been more descriptive. I am looking for what I think is VBA where a message box would pop up on file open. I hope that makes sense. Let me know.

thank you