求两个时间之间有几个休息日

楼主海洋之星	求两个任意时间之间有几个休息日（周六、周日）要求：只能使用公式与函数。试题(1).rar
2楼 mn860429	包含分界点 =SUM(N(MOD(ROW(INDIRECT(B13&":"&C13)),7)={0,1}))
3楼 rongjun	楼主给的参考答案错了吧？公式1： =SUM(INT((C13-FLOOR(B13-{1,2},7)-{0,1})/7)) 公式2（适用2010版）： =NETWORKDAYS.INTL(B13,C13,"1111100")
4楼 JLxiangwei	=C13-B13+1-NETWORKDAYS(B13,C13) =SUM(N(MOD(ROW(INDIRECT("A"&B13&":"&"A"&C13)),7)={0,1}))数组，这公式只针对题目（实用性不强）
5楼 mxqchina	=SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(B3&":"&C3)),2)>5)) 没想到更短点的，应该更好的算法。
6楼 wqfzqgk	=IF(WEEKDAY(B13)=6,C13-B13+3-NETWORKDAYS(B13,C13),IF(WEEKDAY(B13)=7,C13-B13+2-NETWORKDAYS(B13,C13),C13-B13+1-NETWORKDAYS(B13,C13)))
7楼 gouweicao78	2003版： =SUM(--(MOD(ROW(INDIRECT(B13&":"&C13)),7)<2)) 使用分析工具库函数 =C13-B13-NETWORKDAYS(B13,C13)+1 2010版： =NETWORKDAYS.INTL(B13,C13,"1111100")
8楼霏凡	我看看，学习下吧。。
9楼 wshcw	老题,写了几百遍了: =SUM(N(MOD(ROW(INDIRECT(B3&":"&C3)),7)<2))
10楼 zm0115	试题.rar
11楼 wise	数组公式，网上找到的： =SUM(N(WEEKDAY(ROW(INDIRECT("1:"&(C13-B13)))+B13-1)={1,7}))
12楼 piny	普通公式下拉 133字元 E3=INT((C3-B3+1)/7)2+(WEEKDAY(C3)=7)(WEEKDAY(B3)<>1)+2(WEEKDAY(B3)>2)((WEEKDAY(B3)-WEEKDAY(C3))>1)+(WEEKDAY(B3)=1)(WEEKDAY(C3)<>7) ============================================================ 130字元 E3=INT((C3-B3+1)/7)2+(OR(WEEKDAY(C3)=7,WEEKDAY(B3)=1)(WEEKDAY(B3)+WEEKDAY(C3)<>8)+2(WEEKDAY(B3)>2)((WEEKDAY(B3)-WEEKDAY(C3))>1)) ============================================================ 数组公式下拉 120字元 E3=INT((C3-B3+1)/7)2+(OR(WEEKDAY(B3:C3)={1,7})(SUM(WEEKDAY(B3:C3))<>8)+2(WEEKDAY(B3)>2)(SUM(WEEKDAY(B3:C3){1,-1})>1)) ============================================================ 118字元 E3=2(INT((C3-B3+1)/7)+(WEEKDAY(B3)>2)(SUM(WEEKDAY(B3:C3){1,-1})>1))+OR(WEEKDAY(B3:C3)={1,7})(SUM(WEEKDAY(B3:C3))<>8) ============================================================ 116字元 E3=2(INT((C3-B3+1)/7)+(MOD(B3-1,7)>1)(SUM(WEEKDAY(B3:C3){1,-1})>1))+OR(MOD(B3:C3,7)={1,0})(SUM(WEEKDAY(B3:C3))<>8)
13楼悟空师弟	=SUM(--(WEEKDAY(ROW(INDIRECT(B13&":"&C13)),2)>5))
14楼迎客松	=(C3-B3)-NETWORKDAYS(B3,C3)+1
15楼 zhanghi	｛=SUM(--(WEEKDAY(B13+ROW(INDIRECT("1:"&C13-B13)),2)>5))｝试题(2).rar
16楼 wjh619993018	=SUM(N(MOD(ROW(INDIRECT(B13&":"&C13)),7)<2))
17楼 wjh619993018	=C3-B3-NETWORKDAYS(B3,C3)+1
18楼 wjc2090742	=SUM(N(MOD(ROW(INDIRECT(B3&":"&C3)),7)<2)) 试题.rar
19楼 amulee	=C3-B3-NETWORKDAYS(B3,C3)+1
20楼 mcwins	学习中。。
21楼 liuping0928	=INT((C13-B13)/7)*2+IF(MOD(C13-B13,7)+WEEKDAY(B13,2)=6,1,IF(MOD(C13-B13,7)+WEEKDAY(B13,2)>=7,2,0)) 这样对不
22楼 zhanghi	未测试版本： =1+DATEDIF(B13,C13,"d")-NETWORKDAYS(B13,C13) 试题(1).rar
23楼 su11wei18	=SUM((TEXT(B13+ROW(INDIRECT("1:"&C13-B13)),"aaa")={"六","日"})*1)
24楼茄子	看看吧，
25楼 wangg913	2003版： =SUM(N(MOD(ROW(INDIRECT(B13&":"&C13)),7)<2)) 2003版加载分析库或2007版 =C13-B13-NETWORKDAYS(B13,C13)+1
26楼 Zaezhong	=SUM(N(WEEKDAY(ROW(INDIRECT(B13&":"&C13)),2)>5)) 试题.rar
27楼 larkzh	=(C13-B13+1)-NETWORKDAYS(B13,C13) 试题(1).rar
28楼 sharprain	{=SUM(N(WEEKDAY(ROW(INDIRECT(B13&":"&C13)))>5))}，数组公式下拉，结果不太一样呀
29楼半半瓶醋	=C13-B13-NETWORKDAYS(B13,C13)+1
30楼 XIAO_JUN	=C3-B3-NETWORKDAYS(B3,C3)+1
31楼 w83365040371	=C3-B3-NETWORKDAYS(B3,C3)+1
32楼 wh_china2010	=C3-B3+1-NETWORKDAYS(B3,C3)