How to insert dynamically changing date in Excel. Current date is inserted in Excel Cell as shown below. Now the color of B2 has changed into red since the result of the formula is less than 10. If we want to insert a static date value in Excel, we can use short cut key combination 'Ctrl' + ' ' (semi-colon).
Switch to Fill tab, choose the color you want and hit OK. Input the formula “ =B2-TODAY()<=10” in the textbox below. Select this cell, click Home – Conditional Formatting – New Rule.Ĭhoose Use a formula to determine which cells to format as Rule Type. 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.įor example, I hope B2 can turn to red when the remaining time is less than 10 days. I change the due date in B2 to 7, and then the text in C2 changes as well, which proves this method works. In order to check the effect of the reminder. So I can only see a blank cell in C2 for now. 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. Step 2: Click the cell in which the current date is to be displayed. Step 1: Open the spreadsheet into which you want to add the current date. So I input =IF(B2-A2<=10,”DUE”,””) in C2. The Excel current date function might be preferable if you need the data in the cell to update to whatever the current date is. In my case, I want to be alerted when there are less than 10 days left before due date. Then input the due date in B2 directly since it’s fixed.
Press Enter or click anywhere outside the cell, the date will show. It will be update automatically every time I open the file. I create 3 columns in the table and input “ =TODAY()” in A2, which refers to today’s date. In this post, I’ll introduce 2 methods to add a due date reminder in your Excel sheet. Working with the data in Excel spreadsheets often requires a reminder of the due date, such as the due date of receivable.