Forum Discussion
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.
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