考勤表模板.xlsx
2022-08-01T05:10:27.png

注释

出勤请假一天请假半天
×

函数

统计出勤天数,为空时不显示0
=IF(COUNTIF($C3:$AG3,"√")+COUNTIF($C3:$AG3,"半")/2>0,COUNTIF($C3:$AG3,"√")+COUNTIF($C3:$AG3,"半")/2,"")

统计请假天数
=COUNTIF($C3:$AG3,"×")+COUNTIF($C3:$AG3,"半")/2

统计休假和请假天数,并加上写在AK3单元格里的备注
=IF(AI3>2,"调休2天,请假"&AI3-2&"天。",IF(AI3=0,"","调休"&AI3&"天。"))&AK3