Introduction to employee attendance statistics form Employee attendance statistics sheetprocess:
1. Unit name
2. Department name
3. Name
4. Late
5. Leave early
6. Absenteeism from work
7. Actual attendance
8. Remarks
General Tips for Employee Attendance Statistics
1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To allow the system to automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1. "Male", "Female"), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.
Recommended by the editor of Huajun Software Park
Employee attendance statistics sheetIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Annual record of major national economic indicators,Annual statistical table of national economic developmentDownload to get the source file, which you can edit, modify and replace. To download the employee attendance statistics form, go to Huajun Software Park.
it works
it works
it works