如何制作一个能用到退休的考勤表

如何制作一个能用到退休的考勤表

回复
  • 黄哲晨用户
    [[{"txt": "\u8fd0\u7528\u5230\u6761\u4ef6\u683c\u5f0f\u548cdate \u548ccloumn\u51fd\u6570 \u8fd8\u6709\u6570\u636e\u6709\u6548\u6027\u91cc\u7684\u7cfb\u5217\u503c"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u7535\u8111"}, {"txt": "excel"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u8bbe\u8ba1\u597d\u8868\u683c\u5927\u81f4\u6837\u5f0f\u3002\u8868\u683c\u4e2d\u5e74\u6708\u65e5\u7684\u8bbe\u7f6e\u662f\uff1a\u53e6\u4e00\u4e2a\u8868\u683c\u4e2d\u62d6\u62c9\u60f3\u8981\u7684\u5e74\u4efd\uff0c\u6211\u7684\u662f2018-2025\u5e74\uff0c\u7136\u540e\u6570\u636e\u6709\u6548\u6027\uff0810\u7248EXCEL\uff09--\u6570\u636e\u6709\u6548\u6027\uff0c-\u7cfb\u5217\u4e2d\u8bbe\u7f6e\uff0c\u770b\u56fe\u3002\u6708\u548c\u4f11\u606f\u65e5\u540c\u6837\u8bbe\u7f6e"}, {"img": ["https://exp-picture.cdn.bcebos.com/27725684cde34b2ca63c98cd0d0e7c75e4f44365.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/f385f29959430401e62dfdf0d66b04d14829056a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e8c\u6b65\u5f00\u59cb\u8bbe\u7f6e\u6708\uff0c\u51fd\u6570\u4e3a=DATE($B$1,$B$2,COLUMN(A1))\u6ce8\u610f\u5f15\u7528\u7684\u5355\u5143\u683c\u8981\u7edd\u5bf9\u5f15\u7528\u3002\u661f\u671f\u90a3\u884c\u5f15\u7528\u6708\u884c\u7684\u5355\u5143\u683c\u5c31\u884c\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ef4c24ceaad7726bf6368655bf0f64781523b96b.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/05a320a23a42a07ad2c45f81673834bb18efc16a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u73b0\u5728\u5f00\u59cb\u6574\u4e2a\u8868\u533a\u57df\u7684\u683c\u5f0f\uff0c\u7528\u7684\u662f\u6761\u4ef6\u683c\u5f0f\u7b2c\u4e00\u6b65\u662f\u8bbe\u7f6e\u6574\u4e2a\u8868\u65e5\u671f\uff0c\u5982\u679c\u78b0\u52302\u6708\u4efd\u53ea\u80fd28\u5929\u7684\u3002\u81ea\u52a8\u53bb\u6389\u540e\u9762\u7684\u4e0b\u4e2a\u6708\u65e5\u671f\u3002\u6b65\u9aa4\u662f\u9009\u4e2d\u8868\u6700\u540e\u51e0\u5217\u7684\u65e5\u671f\uff0c\u9009\u5728\u6761\u4ef6\u683c\u5f0f\u91cc\u8bbe\u7f6e\u516c\u5f0f=DAY(AE$5)0"}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u516c\u5f0f\u4e2d\u8868\u683c\u6709\u5f88\u591a\u7edd\u5bf9\u5f15\u7528\uff0c\u4e0d\u8981\u641e\u9519\u3002"}]]
    2024-11-22
    1楼
    回复

参与评论

游客评论不支持回复他人评论内容,如需回复他人评论内容请