=NETWORKDAYS(B1,B2,B3:B12)+SUMPRODUCT((B13:B14>=B1)*(B13:B14<=B2)) 转载于:https://blog.51cto.com/leafwf/649509