09-【考勤系统】-05-考勤管理系统.xlsx

7月考勤管理系统返回首页起始日7/1截止日7/31天数31天休息日9天月度合计484天0天0天0天0天0天484天姓名日期7/17/27/37/47/57/67/77/87/97/107/117/127/137/147/157/167/177/187/197/207/217/227/237/247/257/267/277/287/297/307/31应出勤天数病事假年假婚假产假丧假出勤实际出勤合计四五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六事年婚产丧√姓名1√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名2√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名3√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名4√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名5√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名6√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名7√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名8√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名9√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名10√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名11√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名12√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名13√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名14√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名15√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名16√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名17√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名18√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名19√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名20√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名21√√√√√√√√√√√√√√√√√√√√√√22天000002222天姓名22√√√√√√√√√√√√√√√√√√√√√√22天000002222天使用说明：1、输入起始日、截止日，日期星期自动生成，周末自动变色；2、下拉选择输入出勤类型，不同类型自动变色；3、下拉内容可自定义设置，修改AI5-AO5单元格内容，下拉选择内容即自动变化；4、如需新增行，直接下拉行即可；5、为保护公式设置，设置了部分单元格保护，不影响输入。如需更改，点击审阅-取消工作表保护即可，无密码。