How to Set Due Date Reminder in Excel (3 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

After fixing a due date in Excel for any issue, you may want to check if any other date has passed the due date or not and show it with a reminder. This article will show 3 quick and effective methods to set due date reminder in Excel.


Set Due Date Reminder in Excel: 3 Ways

To demonstrate the methods we’ll use the following dataset that represents some buyers’ invoice amounts and due dates.


1. Combine TODAY, AND, and IF Functions to Set Due Date Reminder in Excel

In our very first method, we’ll make a formula to get the due date reminder. For that, we’ll use the TODAY, AND, and IF functions. We’ll check for the date 7 days ahead of the current date. The formula will return Yes if any date passes the due date; otherwise, it will show No. To show the output we added a new column E.

Steps:

  • Activate Cell E5.
  • Type the following formula in it-
=IF(AND(D5<>"",TODAY()+$D$11>=D5),"Yes","No")
  • Then just press the Enter button.

Combine TODAY, AND, and IF Functions to Set Due Date Reminder in Excel

After that, drag down the Fill Handle icon to copy the formula for the other cells.

Combine TODAY, AND, and IF Functions to Set Due Date Reminder in Excel

Soon after, you will get all the outputs like the image below.

Combine TODAY, AND, and IF Functions to Set Due Date Reminder in Excel

⏬ Formula Breakdown:

➤ TODAY()+$D$11>=D5
It will check the date- 7 days ahead of the current date whether it is greater than or equal to the date of Cell D5 or not. It will return as-
TRUE

➤ D5<>””
It will check if the Cell D5 is empty or not and will return as-
TRUE

➤ AND(D5<>””,TODAY()+$D$11>=D5)
Then the AND function will combine both outputs. If any output goes FALSE, it will return FALSE and if both are TRUE, then it will return TRUE
TRUE

➤ IF(AND(D5<>””,TODAY()+$D$11>=D5),”Yes”,”No”)
Finally, the IF function will return Yes for TRUE and No for FALSE.
Yes


2. Apply Conditional Formatting to Set Due Date Reminder in Excel

Here, we’ll learn to apply Conditional Formatting to set a due date reminder by highlighting cells with picked color.

Steps:

  • Select the dates.
  • Later, click as follows: Home > Conditional Formatting > New Rule.

As a result, a dialog box will open up.

Apply Conditional Formatting to Set Due Date Reminder in Excel

  • At this moment, click Format only cells that contain from the Select a Rule Type box.
  • Then, from the Format only cells with section, select less than or equal to from the second box.
  • Later, type the following formula in the third box-
=TODAY()+7
  • After that, click Format.

Soon after, the Format Cells dialog box will appear.

Apply Conditional Formatting to Set Due Date Reminder in Excel

  • In the Fill section, pick your desired color.

I picked a red color.

  • Finally, just press OK, and it will take you back to the previous dialog box.

Apply Conditional Formatting to Set Due Date Reminder in Excel

  • Just press OK.

Now have a look at the conditioned dates which are reminded with the red fill color.


3. Embed VBA Macro to Get a Pop-Up Alert for Due Date

If you like to work with codes, you can easily set pop-up reminder for due dates. The amazing part is you will get the reminder in a pop-up notification box including buyer names.

Steps:

  • Right-click on the sheet title.
  • Then select View Code from the Context menu.

Soon after, a VBA window will open up.

Embed VBA Macro to Get a Pop-Up Alert for Due Date

  • Write the following codes in it-
Option Explicit
Sub Due_Date()
Dim DueDate_Col As Range
Dim Due As Range
Dim PopUp_Notification As String
Set DueDate_Col = Range("D5:D9")
For Each Due In DueDate_Col
    If Due <> "" And Date >= Due - Range("D11") Then
        PopUp_Notification = PopUp_Notification & " " & Due.Offset(0, -2)
    End If
Next Due
If PopUp_Notification = "" Then
    MsgBox "No need to chase any buyer today."
Else: MsgBox "These buyers need chasing today: " & PopUp_Notification
End If
End Sub
  • Finally, just press the Run icon to run the codes.

Embed VBA Macro to Get a Pop-Up Alert for Due Date

Have a look, a pop-up notification message box is giving an alert with the buyer names.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


Conclusion

I hope the procedures described above will be good enough to set a due date reminder in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

5 Comments
  1. Thanks a lot for this protocol. I have managed to include all 3 methods in my excel file but now I would like to have the marco running when I’m opening the workbook. I have been trying this with Private Sub Workbook_open() but I’am not really sure how I can integrate this is in the codes.

    • Hello HOPE, thanks for your feedback. To do that, place Private Sub Workbook_open() in a new module and then call the previous Sub within it. I hope, it will work.

  2. I have run the VBA but on another workbook sample but it is not showing the names of clients just the dates.

    • Good day, Daniel,

      The issue you’re having might be because your workbook’s data range differs from the data range specified in our code.

      Change the data range according to your worksheet.

      This might be the solution to your issue. I’d appreciate it if you could send me the worksheet you’re working on so that I can better understand your issue and give you an exact solution.

      Regards
      Sakibul Hasan Nahid | ExcelDemy Team

  3. Hello.

    Once the code is embedded, will I get a daily pop-up notification for the specific day’s “buyers that need to be chased” as soon as i open the file? Also, once I have pressed “ok” on the pop-up notification, is there a way to bring it back up after it disappears?

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo