Excel如何计算两日期之间的工作日数

[[{"txt": "\u5f88\u591a\u5c0f\u4f19\u4f34\u53ef\u80fd\u9700\u8981\u8ba1\u7b97\u9664\u53bb\u661f\u671f\u516d\u65e5\u4ee5\u53ca\u8282\u5047\u65e5\u7684\u5de5\u4f5c\u65e5\u6570\u91cf\uff0c\u90a3\u4e48\u73b0\u5728\u5c31\u6765\u6559\u4f60Excel\u5982\u4f55\u8ba1\u7b97\u4e24\u65e5\u671f\u4e4b\u95f4\u7684\u5de5\u4f5c\u65e5\u6570"}, {"img": ["https://exp-picture.cdn.bcebos.com/65ba880b31210561499c085a08aee8d7582a6a96.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u64cd\u4f5c\u7535\u8111\uff1a\u60e0\u666e "}, {"txt": "\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 10"}, {"txt": "WPS 11.1.0\u7248\u672c"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u9996\u5148\u6253\u5f00Excel\u6587\u4ef6\uff0c\u7f16\u8f91\u6216\u8005\u8f93\u5165\u8981\u8fdb\u884c\u8ba1\u7b97\u7684\u65e5\u671f\uff0c\u8fd9\u91cc\u8981\u5148\u8f93\u5165\u8282\u5047\u65e5\uff08\u56e0\u4e3a\u7cfb\u7edf\u4e0d\u4f1a\u81ea\u52a8\u8bc6\u522b\u60a8\u7684\u8282\u5047\u65e5\uff09"}, {"img": ["https://exp-picture.cdn.bcebos.com/e996472ae3efe078400e8205b96c576698cf6596.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u63a5\u7740\u70b9\u51fb\u3010\u516c\u5f0f-\u63d2\u5165\u51fd\u6570\u3011\u529f\u80fd"}, {"img": ["https://exp-picture.cdn.bcebos.com/562787cf02532f6378babd85699147e832e05c96.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u5728\u67e5\u627e\u51fd\u6570\u4e2d\u8f93\u5165\u3010networkdays\u3011\uff0c\u7136\u540e\u70b9\u51fb\u786e\u5b9a"}, {"img": ["https://exp-picture.cdn.bcebos.com/46a92de039723d03d9d56335bb486143d6d45796.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u5c06\u3010\u5f00\u59cb\u65e5\u671f\u3001\u7ec8\u6b62\u65e5\u671f\u3001\u5047\u671f\u3011\u7684\u5355\u5143\u683c\u8f93\u5165\u5230\u5bf9\u5e94\u6846\u4e2d\uff0c\u70b9\u51fb\u786e\u5b9a\u5373\u53ef\u5f97\u5230\u8ba1\u7b97\u7ed3\u679c"}, {"img": ["https://exp-picture.cdn.bcebos.com/3fc72e486143d7d42f0e59587da75f0f832b5096.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5982\u679c\u6709\u591a\u4e2a\u8981\u8ba1\u7b97\u7684\u65e5\u671f\u5217\uff0c\u90a3\u4e48\u76f4\u63a5\u5c06\u9f20\u6807\u653e\u5728\u53f3\u4e0b\u89d2\u5f62\u6210\u9ed1\u8272+\u518d\u5411\u4e0b\u62c9\u52a8"}, {"img": ["https://exp-picture.cdn.bcebos.com/f7e6410f822b74ee710d16abda2c8cf1d9a74a96.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6700\u540e\u5373\u53ef\u5f97\u5230\u5168\u90e8\u8981\u8ba1\u7b97\u7684\u7ed3\u679c\u6ce8\u610f\uff1a\u8282\u5047\u65e5\u5355\u5143\u683c\u8981\u7edd\u5bf9\u5f15\u7528"}, {"img": ["https://exp-picture.cdn.bcebos.com/d9e638334884cde33e130b5df07f860e7d754296.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u603b\u7ed3"]}, {"txt": "1\u3001\u9996\u5148\u7f16\u8f91\u6216\u8005\u8f93\u5165\u8981\u8fdb\u884c\u8ba1\u7b97\u7684\u65e5\u671f\uff0c\u70b9\u51fb\u516c\u5f0f-\u63d2\u5165\u51fd\u6570\u529f\u80fd2\u3001\u5176\u6b21\u67e5\u627e\u51fd\u6570\u4e2d\u8f93\u5165networkdays\uff0c3\u3001\u6700\u540e\u5c06\u5f00\u59cb\u65e5\u671f\u3001\u7ec8\u6b62\u65e5\u671f\u3001\u5047\u671f\u7684\u5355\u5143\u683c\u8f93\u5165\u5230\u5bf9\u5e94\u6846\u4e2d\u5373\u53ef\u5f97\u5230\u8ba1\u7b97\u7ed3\u679c"}, {"img": ["https://exp-picture.cdn.bcebos.com/7a3e980e7c75e5f487cab3beb1ceaad7736bbc96.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]