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.

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

  6. Roslin says:

    Hi Guys,

    Thanks for being helpful!!

    1. Sandra says:

      🙂 my pleasure

  7. Vidhi Rane says:

    Thanks A lot for this information

  8. Dana says:

    How would I format this for multiple cells? I used the second method suggested, but let’s say I would like that same conditional formatting (=B2-TODAY()<=10) to apply not just to b2 but all the cells in the b column (or even columns b,c, and d). Would I have to go into each cell and rewrite the formula plugging in b3, b4, b5, etc? It seems very tedious to go cell by cell so I didnt know if there was another way! Thanks 🙂

    1. Sandra says:

      Drop-down fill is a good choice.

  9. smith says:

    Thanks for the article with simple examples. It’s crystal clear & easy to absorb for beginners.

  10. Camila Lourdes says:

    OMG, been looking mfor this on many sites and this one was the only that could help me. Thanks a mill. If anyone needs the template I’m happy to help

Leave a Reply

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