Excuse me, how to set a reminder before the date expires in the EXCEL table?

Using Excel as a reminder, the form is limited, at most, it will change color and pop up windows. If you want a more advanced reminder, you can consider using software. For example, there are three ways to remind Huachuang's online list: email notification, short message and short message in the system. The specific features are:

1. You can flexibly set the reminding time, reminding conditions, letter title and letter content. The system can automatically generate a reminder email or SMS according to the data and send it out automatically.

2. Reminder timing refers to actions or events that trigger reminders. There are two kinds: data operation triggers reminder, and expiration triggers reminder;

3. Reminding conditions refer to what conditions are met before reminding, such as customer level reaching A level and sales amount reaching1000 ...;

4. For the reminder caused by data operation, the operation of adding, deleting and modifying records can be taken as the reminder opportunity, and a reminder message will be sent whenever data is added, deleted or modified.

5. For the reminder caused by expiration, you can use the date field (such as birthday) in the data table as the expiration time, and send a reminder letter as soon as the time arrives. You can schedule the time range of the reminder, such as one month before the birthday to the birthday; The frequency of reminders can be reserved, such as one-time reminder, hourly reminder, daily reminder, weekly reminder, monthly reminder and annual reminder. That is to say, during this time, remind at this frequency.

The design idea of the system is the same as excel, which can manage all kinds of data without programming and creating tables freely. Excel users are easy to get started.

I hope what I wrote can help you and broaden your horizons.