A1/B1分别是起始日期和结束日期,
周五周六是假期,周日是工作日
=NETWORKDAYS(A1,B1)-((WEEKDAY(A1)>5)+(WEEKDAY(B1)>5))
周五周六是假期,周日是工作日
=SUM(N(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),15)>2))-1
A1/B1分别是起始日期和结束日期,
周五周六是假期,周日是工作日
=NETWORKDAYS(A1,B1)-((WEEKDAY(A1)>5)+(WEEKDAY(B1)>5))
周五周六是假期,周日是工作日
=SUM(N(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),15)>2))-1
转载于:https://my.oschina.net/monkeybiao/blog/850479