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