Latest employee attendance sheet template It is the voucher for employees to go to work every day, and also the voucher for employees to receive wages, because it records the number of days employees go to work. The latest employee attendance form template is provided by Huajun Software Park for free download. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free download of the latest employee attendance form template, please follow Huajun Software Park.
Tips for using the latest employee attendance sheet template
Common fields of the latest employee attendance form template include
1. Unit name Department name , Job No ,, Position, Name
2. Late , Leave early Absenteeism Actual attendance
3. Remarks
record : Included in the attendance sheet Early leave, absenteeism, sick leave, personal leave, leave The situation.
General Skills of the Latest Employee Attendance Form Template
1: Multi condition count
Requirements: count the number of people whose statistics department is production and whose posts are the main operators
The formula is:
=COUNTIFS(B2:B9,F2,C2:C9,G2)
COUNTIFS function counts the number of cells that meet multiple specified conditions in the condition area. The general usage is:
=COUNTIFS (condition area 1, specified condition 1, condition area 2, specified condition 2...)
2: Condition lookup
VLOOKUP function has always been a lover of the public. The syntax of the function is:
VLOOKUP
To query the job title of the employee name in F5 cell.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
When using this function, you should pay attention to the following points:
1. The fourth parameter generally uses 0 (or FASLE) to search by 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 number of the return value in the search range.
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 lookup value must be in the first column in the query area.
Update log of the latest employee attendance form template:
Sweep the bug out and carry it out to the end
Optimize user feedback and improve detail experience
Recommended by the Chinese military editor:
The latest employee attendance sheet template software feels really good! The editor specially tested it and it was really good to use, 360 Browser These are all very good software tested by small editors. Come and choose one that suits you!