Forum Discussion

lrivera822's avatar
lrivera822
Copper Contributor
May 28, 2018

Help with an excel formula

I want to receive an alert when a document lacks 30 days to expire and that continue to indicate it during those 30 days. 

 If C9 is greater than -30 but less than 0 is about to expire.

Formulas & Functions
Need Help

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    May 29, 2018

    Hi,

     

    I got two solutions for you!

    First one by using a formula, and the second by using VBA.

     

    The formula solution will notify you in another cell on the same worksheet by displaying the notification text in the cell.

     

    But the second solution will notify you each time you open the workbook and display a message box when the document is about to expire or expired!

     

    Please find the attached files.

     

    Hope that helps

    Haytham

Resources