Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

2 Ways to Add Auto Reminders on Due Date in Excel

Date:2019-7-17 Author:Cordelia

Working with the data in Excel spreadsheets often requires a reminder of the due date, such as the due date of receivable. In this post, I’ll introduce 2 methods to add a due date reminder in your Excel sheet. Hope it can be helpful to your work.

1. Functions

See the example below. I create 3 columns in the table and input =TODAY()” in A2, which refers to today’s date. It will be update automatically every time I open the file.

2 Ways to Add Auto Reminders on Due Date in Excel

Press Enter or click anywhere outside the cell, the date will show.

2 Ways to Add Auto Reminders on Due Date in Excel

Then input the due date in B2 directly since it’s fixed.

2 Ways to Add Auto Reminders on Due Date in Excel

In my case, I want to be alerted when there are less than 10 days left before due date. So I input =IF(B2-A2<=10,”DUE”,””) in C2. It means when the result of B2-A2 is less than 10 or equals to 10, the text of “DUE” will show in the cell. Otherwise it shows as blank. So I can only see a blank cell in C2 for now.

2 Ways to Add Auto Reminders on Due Date in Excel

In order to check the effect of the reminder. I change the due date in B2 to 2019/7/27, and then the text in C2 changes as well, which proves this method works.

2 Ways to Add Auto Reminders on Due Date in Excel

2. Conditional Formatting

If you don’t want to add a new column as reminder in the sheet, you can try another method to make the cells change color when the expiration date approaches.

For example, I hope B2 can turn to red when the remaining time is less than 10 days.

2 Ways to Add Auto Reminders on Due Date in Excel

Select this cell, click HomeConditional FormattingNew Rule.

2 Ways to Add Auto Reminders on Due Date in Excel

Choose Use a formula to determine which cells to format as Rule Type. Input the formula “=B2-TODAY()<=10” in the textbox below. Then click Format.

2 Ways to Add Auto Reminders on Due Date in Excel

Switch to Fill tab, choose the color you want and hit OK.

2 Ways to Add Auto Reminders on Due Date in Excel

Now the color of B2 has changed into red since the result of the formula is less than 10.

2 Ways to Add Auto Reminders on Due Date in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

5 thoughts on “2 Ways to Add Auto Reminders on Due Date in Excel”

  1. Pingback: 4 Tips to Overcome Procrastination for Efficient Work - [Jcount.com]
  2. vurtil opmer says:

    Just wanna input that you have a very decent internet site, I like the layout it actually stands out.

  3. vurtilopmer says:

    There is noticeably a bundle to know about this. I assume you made certain nice points in features also.

  4. LOCAL SEO SERVICES says:

    Great, thanks for sharing this post.Really thank you! Cool.

  5. Eddy Win says:

    How to copy & paste the formula conditioning format for the next column

    1. Cordelia says:

      Hi Eddy, I’m not sure what you refer to, but using the shortcuts [Ctrl+C], [Ctrl+V] can copy and paste not only the text in the cell but also the conditional formatting rule.

Leave a Reply

Your email address will not be published. Required fields are marked *