excel vacation calendar

About the unit annual vacation statistics, in fact, is a very complex work, because the number of days and each person's seniority, coupled with some comrades like to separate the annual leave, so that will appear to the end of how many days he himself also confused. In order to avoid such a situation, the comrades in charge of this work must be prepared in advance to master and count all the annual leave to ensure that everyone's interests are not lo

1. Relationship between length of service and the number of days on vacation.If you have worked for less than 10 years, you should take 5 days off. If you have been working for less than 10 years, you should take 10 days off. If you have been working for more than 20 years, you should take 15 days off. Therefore, if you want to do a good job in this project, you must master the exact participation time of all the comrades. This is the premise.2. Use the function to automatically differentiate th

1, as shown in the following figure we have prepared a test Excel file, we open it, as shown in the following figure. 2. We enter =DATEDIF in the E7 cell (D7,today (), "Y" here will only count the data of a cell, if we want to count all the cursor to the E7 cell, and then when the corner mouse is "+", we drag down directly to statistics of this data, as shown in the following figure. 3, now we move the cursor to the F7 cell, and then enter

At the beginning of the new year, make a new year calendar to give someone New Year's greetings, this mind is very important. There are many ways to make a new Year's calendar, but have you ever tried it with an Excel form in office? below to introduce you to make the calendar with

Perhaps a lot of people because of traditional habits, will have a lunar birthday, so bring a curious question, birthday to which year the lunar calendar will coincide? Do you have to check it? Well, you are ruthless, although there are 19 years of the lunar calendar will coincide one said, in fact, the number of years interval is indeed nearly 19 times times the number, the "Public Lunar fun query. xls" To

How does Excel insert a Calendar control? 1, first, open the Excel 2007 software, and then in the top left corner of the table has an Office Button, and then the right mouse click, as shown. Then select "Customize Quick Access Toolbar" in the dialog box that pops up 2, then in the pop-up "Excel