æ¹æ³ä¸ï¼
è¾å
¥ä»¥ä¸å
¬å¼
=NETWORKDAYS.INTL(A1,A2,11)
å¾å°A1为å¼å§æ¥æï¼A2为ç»ææ¥æï¼ä¸å
æ¬ææ天å¨å
ç天æ°
æ¹æ³äºï¼
è¾å
¥
=SUMPRODUCT((WEEKDAY(ROW(39965:39980),2)<>7)*1)
å
¬å¼è¡¨ç¤ºï¼å°A1åºåå·åA2åºåå·ç»æçè¡å·ï¼éè¿WEEKDAY(æ°æ®,2)计ç®ï¼ä¸ä¸º7çæ°æ®ï¼å°±æ¯ç¬¦åè¦æ±ç天æ°ã
å¦ææ¯å¨æ两个ä¼æ¯æ¥è®¡ç®ï¼é£ä¹å¯ä»¥ä½¿ç¨
=NETWORKDAYS(A1,A2)
温馨提示:答案为网友推荐,仅供参考