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

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.

🕰️Timestamps
00:00 Introduction
00:21 Show reminder if due date is within 7 calendar days
00:36 Calculate the number of days until due date
01:24 Write a logical test using the AND function
02:11 Use IF AND to return the reminder
03:02 Delete the helper column and combine formulas
03:34 Highlight the reminders using conditional formatting
04:50 Show reminder if due date is within 7 working days
05:04 Use AND to create the logical test
06:48 Use IF AND to return the reminder
07:13 Delete the helper column and combine formulas
07:38 Hightlight the reminders using conditional formatting

#exceltutorial #exceltips

[nadermounir]

Thank you very much for this nice video 📹 👍

[khushikhushi]

Wow you have explained it in so simple method. Thankyou very much

[andrewalexanderkisten]

Thanks, brilliant video - helped me with my problem 👍

[MyDearFriend]

This might be a silly question and I apologies if it is but wouldn't the formula also work if you wrote it as "=IF(And(B4-Today()<-7), "Reminder", "")" why do we need the extra section of B4-Today()>0? I am sorry for my misunderstanding in advanced! thank you for the amazing video

[katelovely]

The video says you can download the file in the description but I can't find it! Can you please post
the link?

[ucheezeukwu]

Do you get a notification after setting a reminder that you don't need go back to the excel to see the reminder you set

[d.cbotha]

Not working, getting a formula error.