Tools/materials excel

0 1 As shown in the figure, fill in the repayment dates of credit cards and loans in cells D4 to D8.

Enter the formula = date (year (today ()), month (today ()), D4) in the E4 cell, and then press Enter to confirm.

Fill the formula in E4 cells into E4 to E8 cells to get the repayment date of each month, and then select the conditional format in the Start toolbar in turn.

Click and select New Rule from the drop-down menu of conditional format.

Select "Set cells to be formatted by formula" in the pop-up new conditional rule, and enter the formula = AND(E4- Today () =0) below, which means to find the date within 5 days. After entering the formula, click Format.

Select the Font tab in the Cell Format dialog box, and then select a color from the font colors.

Select the cell fill color in the Fill tab.

Click OK after selecting a color to return to the conditional format dialog box, and continue to click OK.

Click OK to see the effect. My date today is March 23rd, and the displayed result is that the content will be displayed within 5 days from today.

Special tips on how to quickly enter function formulas in other cells can be found in other guides I have written. The whole process seems to be more, but in fact, you will be very skilled after practicing a few times.

Second, how to use Excel to remind repayment due

Tools/materials excel

0 1 As shown in the figure, fill in the repayment dates of credit cards and loans in cells D4 to D8.

Enter the formula = date (,month (today ()), D4), and then enter.

03 Fill the formula in E4 into E4 to E8 cells to get the repayment date of each month, and then press.

04 conditional format drop-down menu

Set the cells to be formatted in the new formula that pops up, and enter the formula = AND(E4- Today () =0) below, which means to find the date within 5 days. Enter the formula and click "Format".

Select the Font tab in the Cell Format dialog box and choose a font color.

Select a color in the Fill tab.

Select a color and click OK.

Click OK to see the effect. Today's date is March 23, and the result is that all the contents in five days from today are

Special tips on how to quickly input function formulas into other cells can be found in other guides I have written. You will be very skilled after practicing a few times.

Third, how to use Excel as a reminder of repayment due?

1. As shown in the figure, fill in the repayment dates of credit cards and loans in cells D4 to D8.

2. Enter the formula = date (year (today ()), month (today ()), D4) in the E4 cell, and then press Enter to confirm.

3. Fill the formula in E4 cells into E4 to E8 cells to get the repayment date of each month, and then select the conditional format in the start toolbar in turn.

4. Click and select New Rule from the drop-down menu of conditional format.

5. Select "Set cells to be formatted by formula" in the new conditional rule that pops up, and enter the formula = AND(E4- Today () =0) below. The formula means to find the date within 5 days. Enter the formula and click "Format".

6. Select the Font tab in the Cell Format dialog box, and then select a color from the font colors.

7. Select the cell fill color in the Fill tab.

8. Click OK after selecting a good color to return to the conditional format dialog box and continue to click OK.

9. Click OK to see the effect. Today's date is March 23, and the displayed result is the content within five days from today.

Special tips

As for how to quickly enter function formulas in other cells, you can see other guides I wrote. The whole process seems to be more, but in fact, you will be very skilled after practicing a few times.

4. How to make a form under EXCEL to remind the due date of accounts receivable?

Term = round (yearfrac (C4，B4)，)&； "Duration"

Due reminder = IF((C4- Today ())