注释
出勤 | 请假一天 | 请假半天 |
√ | × | 半 |
函数
统计出勤天数,为空时不显示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