Ravi Sir's Cards › Excel
Employee Attendance Management System in Excel (card 2 of 2)
Revision card 2 for Employee Attendance Management System in Excel: Weekly offs plus holidays: =COUNTIF(D6:AH6,"WO")+COUNTIF(D6:AH6,"H") gives 5; Payable days before the late rule: =AI6+AL6+AM6 gives 31; Working days in the month: =DAY(EOMONTH(Setup!$B$3,0))-AM6 gives 26.
Read card text
What this card says
2 for Employee Attendance Management System in Excel: Weekly offs plus holidays: =COUNTIF(D6:AH6,"WO")+COUNTIF(D6:AH6,"H") gives 5
Payable days before the late rule: =AI6+AL6+AM6 gives 31
Working days in the month: =DAY(EOMONTH(Setup!$B$3,0))-AM6 gives 26.
Learn this in the lesson: Employee Attendance Management System in Excel: Monthly Codes, Leave Balance, Late Marks and Dashboard