考勤表(自动计算出勤)

,1月份考勤明细表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,序号,姓名,入职时间,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,统计区域,,,,,,,

,,,,1日,2日,3日,4日,5日,6日,7日,8日,9日,10日,11日,12日,13日,14日,15日,16日,17日,18日,19日,20日,21日,22日,23日,24日,25日,26日,27日,28日,29日,30日,31日,加班,事假,病假,旷工,出勤,出勤天数,,剔除双休日出勤天数

,1,姓名1,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,22

,2,姓名2,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,3,姓名3,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,4,姓名4,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,5,姓名5,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,6,姓名6,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,7,姓名7,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,8,姓名8,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,9,姓名9,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,10,姓名10,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,11,姓名11,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,12,姓名12,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,13,姓名13,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,14,姓名14,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,15,姓名15,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,16,姓名16,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,,,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,,,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,,,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,,,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,,,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,,,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,28天,,

,,,,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,,,,,31,31天,,

,,,,√,√,休,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,√,病,√,√,√,√,√,√,√,√,√,,,,1,,28,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,