How to set up an automatic reminder for excel expiration

1. Start Excel, create a new document, and save it with a name (such as "Reminder. xls”）。

2. Press the "Alt+F11" key combination to enter the VBA state.

3. In the "Project Explorer" window on the left, select "vbaproject(Reminders. xls)" option to execute the "Insert Module" command to insert a new module.

4. Enter the following ** into the area on the right:

sub auto_open() 'Set up an auto-run macro - auto open

timevalue("08:30:00"), "tx" 'Set the reminder time - 08:30:00 (can be modified as needed), and set the reminder macro - tx.

timevalue("09:30:00"), "tx" 'Set a reminder one more time.

end sub

sub tx() 'Set up a macro that displays the alert message (the name matches the name called in the autorun macro above).

msg = msgbox("Notification sheet.

Three, Lee. Fourth, Wang Wu judges participated in the afternoon evaluation! ", vbinformation, "Hurry up and hit **") 'Set the message and title in the reminder dialog box (the message content is in the front, and the dialog box title is in the back, please enter it as needed).

end sub

Note: In the above **, the English single quotation marks and the characters following them are the interpretation of **, and can be ignored when actually entering. If you set multiple reminder macros (tx1, tx2......And set the time of the call separately in the automatic running macro, which can realize the timed reminder of multiple messages.

5. After the input is completed, exit the VBA state and save the workbook document.

6. Later, as soon as you get to work, start Excel and open the above workbook document. As soon as the set time is up, the system will immediately pop up a prompt box.

excel how to set up automatic reminder of contract expiration, I teach you!

<>2. Enter the entry time of the new employee in cell A2, for example: 2008 5 8 format.

3. After knowing the exact time of entry, we use the input formula in the cell B2 to quickly calculate the expiration time of the one-month probationary period.

4. Fill in the calculated expiration time downward, so that you don't have to enter them one by one, and you can also avoid date input errors.

5. Enter the formula in the cell C2 to check whether you need an expiration reminder. =and expiration time, minus today's time, less than or equal to 15, expiration time minus today's time greater than or equal to 0.

6. Fill the content of cell C2 downward, at this time we see that there are two situations, which are false and expired, and true is to remind.

7. In the d2 unit of the probationary period reminder, use if=and expiration time to subtract today's time, less than or equal to 15, the expiration time minus today's time is greater than or equal to 0, and the expiration time minus today's time has expired.

Let's share how to set a date expiration reminder in Excel**.

1. First of all, in the open **, check the cell that needs to set the date expiration reminder.

2. At this time, click "Start - Conditional Formatting" above.

3. In Conditional Formatting, click "Highlight Cell Rule - Date of Occurrence".

4. On the pop-up page, click the time option "Yesterday" and select "Next Month".

5. After setting the reminder time, click "OK".

6. Return to the date interface, and you can see that the expiration date of the next month has been highlighted.

Use the excel function to set up overdue reminders for **. It can let you know which customers are overdue, which is very useful when you apply for a membership card for a customer. I will teach you how to set the overdue reminder function in excel, I hope it will help you!

Excel overdue reminder function setting method Suppose there are two columns A and B in Excel**: date and prompt. When the date in column A is more than 7 days old, column B automatically displays a reminder that "the date has expired".

Figure 1 of the setting method of the Excel overdue reminder function=if(a2<>"if(now()-a2<7,""It has been overdue"),Figure 2 of the setting method of the excel overdue reminder function3 Explain:"= is an indication that a function may be entered inside the cell. After that, the if function is used.

This is one of the most basic, and almost the most important, functions. Its format is if (conditional, true, not true). a2<>"is a condition of if (since there is also an if nested inside, we call the outer if a big if, and the inner one a small if), which means that a2 is not equal to null, and <> means that it is not equal to the oak.

if(now()-a2<=7,""It's overdue") is the "establishment" of the big if format. "Yes, when the big if condition is not true, the cell does not output content. In other words, when the content of A2 is not empty, a small if is executed, and the cell does not output content when it is empty.

Similarly, the condition for a small if is now()-a2<7, where now() is a function that outputs the current time. When a2 is not empty, and the time in the current time -a2 is less than 7, the cell does not output content, otherwise, it indicates that the expiration date has expired.

3.Excel is a way to display the date of the day.

4.How to set excel can only enter the date of this month.

5.How to solve the problem that the excel**date cannot use the extension area.

6.Excel2016 how to use days360 functions.

The materials we need to prepare are: computer, excel**.

2. Then we enter "=if(b2-a2<=10,) in the rear**"Reminders","

3. When the number of days of "Today's Date" and "End Date" is less than 10 days, the word "Reminder" will appear on the bulletin board.

<> as shown in the figure, enter the formula in cell B2: =if(datedif(A2,Today(),D")>0,"And there is"&datedif(a2,today(),d"& days expire","Expired")。Formula Analysis:

datedif(a2,today(),d"This formula is used to calculate how many days the date column is separated from today, the datedif function, the first parameter is the start date, the second parameter is the end date, and the third parameter is whether the result of the calculation returns the number of days, years, or months. If the if function is used to judge, if it is greater than 0, it is not expiration, then it returns "how many days are left to expire", and the expired one shows "expired", which realizes automatic judgment.

Note that the today function is a volatile function, that is, open the file every day to save it, the value will be updated, and the return value of the today function depends on the system date of the computer, if the system date is set incorrectly, then the value of the today function is also incorrect.