How to Create Reminders in Excel | Due Date Reminder Formula | Conditionally Format Before Expired

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial, I explain how to create reminders in Excel x no of days before a due date or expiry date. This can be done with an IF AND formula and/or with conditional formatting. In my example, I create a reminder if a due date is within 7 calendar days or seven working days. The same methods can be used to set reminders for due dates within 14 or 28 days.

Credit Chester Tugwell

Please support our Sponsors here :
300 Frameworks Of Wealth