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 :
