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

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.


Download Practice Workbook

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


3 Ways to Set Due Date Reminder in Excel

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

Read More: How to Do SUMIF Date Range Month in Excel (9 Ways)


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.

Read More: How to Use SUMIFS to SUM Values in Date Range in Excel


Similar Readings:


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

If you like to work with codes then there is good news for you that you can easily set a reminder for due dates. And 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.

Read More: Excel VBA: Filter Date before Today (With Quick Steps)


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

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. 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.

2 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.

Leave a reply

ExcelDemy
Logo