Electronic version of attendance sheetTips How to make an electronic version of the attendance sheet?
1. Open Excel and enter 1 and 2 in cells A1 and B2.
2.After 28-Tuesday, enter the number of days of attendance, annual holidays, public holidays, personal leave, sick leave, number of late arrivals, number of absenteeism days, and number of days of compensatory leave, and adjust the column width to 2.38.
3. Enter under the name: Description. Enter the symbol content on one line (× sick leave △ personal leave □ public leave ※ absenteeism ☆ tardiness O normal leave ▲ compensatory leave), and on the next line enter the status of whether employees owe leave each month.
Features of using attendance sheet
1. Display the number of days according to different months.
2. Highlight the weekend.
3. Automatically count attendance numbers.
4. The attendance sheet can help the company to manually summarize data.
5. The attendance sheet can easily understand the attendance status of company personnel, as well as lateness, early departure, absenteeism, sick leave, personal leave, vacation, etc., which is the basis for calculating the wages of labor personnel.
General Tips for Electronic Version of Time Attendance Sheet
1. The fourth parameter is generally set to 0 (or FASLE) for exact matching.
2. The column number in the third parameter cannot be understood as the actual column number in the worksheet, but specifies the column in the search range of the return value.
3. If the search value is inconsistent with the data type of the data area keyword, the error value #N/A will be returned.
4. The search value must be located in the first column in the query area.
3: Multi-condition search.
Recommended by Huajun editor
Electronic version of attendance sheetIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Customer Order Tracking Form,Enterprise application formDownload to get the source file, which you can edit, modify and replace. To download the electronic version of the attendance sheet, go to Huajun Software Park.





















Useful
Useful
Useful