可德 发表于 2021-12-15 23:09:00

公式求助

检查人员休假时段内是否包含法定节假日

卓闻君 发表于 2021-12-26 21:22:45

=IF(SUM((G$2:G$12>=C2)*(G$2:G$12<=D2)),"是","")

东岭紫雪 发表于 2022-3-21 15:45:51

=IF(NETWORKDAYS.INTL(C2,D2,"0000000",$G$2:$G$12)<5,"是","否")
页: [1]
查看完整版本: 公式求助