excel公式
排除假期和周末,计算工作日的2种方式。
AF1496开始日期,55需要延迟的天数,AI1487:AI1494需要排除的节假期
=WORKDAY(AF1496,55,AI1487:AI1494)
=WORKDAY(AF1496,55,{"2020/10/1","2020/10/2","2020/10/3","2020/10/4","2020/10/5","2020/10/6","2020/10/7","2020/10/8"})
...
原创
2020-09-25 17:51:30 ·
99 阅读 ·
0 评论