求大神！在Excel中已知开始日期和结束日期，要得到中间的日期用数字1-31怎么做？ EXCEl如何计算处理时间，请各位大神帮忙！！
\u5404\u4f4dexcel\u5927\u795e\u5982\u4f55\u5b9e\u73b0\u8fd4\u56de\u5bf9\u5e94\u6570\u5b57\u7684\u65e5\u671f\uff1f\u516c\u5f0f\u4e3a:
=INDEX(B$1:F$1,ROUND(A3,0))
\u5982\u56fe\u6240\u793a:
\u63d0\u95ee\u7684\u6587\u5b57\u8bf4\u660e\u6709\u70b9\u95ee\u9898\u5427\uff0c\u5f00\u59cb\u65f6\u95f42019\u5e74\uff0c\u7ed3\u675f\u65f6\u95f42018\u5e74\uff1f
\u5982\u56fe\uff1a
D2=(INT(B2)+MIN(MAX(MOD(B2,1),9/24),17/24)-(INT(A2)+MIN(MAX(MOD(A2,1),9/24),17/24)))*24-(INT(B2)-INT(A2))*16
\u7528\u65f6\u95f4\u683c\u5f0f\u7684\u8bdd\uff1a
E2=TEXT(D2/24,"[h]:mm")
公式:
=IFERROR(SMALL(DAY(ROW(INDIRECT($A$1&":"&$A$2))),ROW(A1)),"")
数组公式按 Ctrl+Shift+Enter 结束公式 下拉
假设B2、C2单元格是开始和结束日期，则D列中可以用公式：
=IF(DAY($B$2)-1+ROW(A1)<=DAY($C$2),DAY($B$2)-1+ROW(A1),"")
复制并下拉即可
=LEFT("1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31",FIND(DATEDIF("2019-8-1","2019-8-9","d"),"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31"))
时间可以引用你单元格的时间
绛旓細鍦⊿heet2鐨凢2鍗曞厓鏍艰緭鍏ヤ互涓嬪叕寮忥紝鐒跺悗鍚戜笅濉厖鍏紡 =IFERROR(VLOOKUP(B2,Sheet1!B:F,5,0),"")
绛旓細杩欎釜鍙互瀹炵幇鐨锛屽亣璁剧涓涓紵 鍦╞2鍗曞厓鏍硷紝鍙傝冭緭鍏ワ細=RANDBETWEEN(H2/SUM(C2,E2,G2)*0.9,H2/SUM(C2,E2,G2)*1.1)d2杈撳叆锛=RANDBETWEEN(H2/SUM(C2,E2,G2)*0.9,H2/SUM(C2,E2,G2)*1.1)f2杈撳叆锛=(H2-B2*C2-D2*E2)/G2 鐒跺悗鍒嗗埆涓嬫媺鍗冲彲銆傚叕寮忎腑 0.9 鍜1.1鏄皟鏁寸殑姣旂巼...
绛旓細鍗曟鏃堕暱=DATEDIF(TEXT(A3,"0000-00"),TEXT(B3,"0000-00"),"M")锛屽啀鎶婃墍鏈夋鏁扮殑鐩稿姞銆
绛旓細D2鍏紡濡備笅锛岀劧鍚庝笅鎷夊～鍏呭嵆鍙 =AVERAGE(OFFSET($F$1,MATCH(A2,F$2:F$4,0),MATCH(B2,G$1:W$1),1,C2-B2+1))
绛旓細1銆佸厛濉垪濂芥瘡浣嶅憳宸鐨瀹炲彂宸ヨ祫 2銆佸湪搴斿彂宸ヨ祫鏍廎4鍗曞厓鏍煎唴杈撳叆鍏紡=ROUND(MAX((H4-3500-{0,105,555,1005,2755,5505,13505})/(1-{0.03,0.1,0.2,0.25,0.3,0.35,0.45})+3500,H4),2) 鍚庡洖杞 3銆佹嫋鍔‵4鍗曞厓鏍煎彸涓嬭鐨勯粦鍗佸瓧鍚戜笅鍒版渶鍚庝竴鏍 4銆佸湪涓◣鏍廏4杈撳叆鍏紡锛滷4-H4 璁＄畻...
绛旓細if sumthis>10 and sumthis <25 then Range("b" & b) = c & "," & d & "," & e & "," & f b = b + 1 '璺宠浆鍒颁笅涓鍗曞厓鏍 Next Next Next Next Next End Sub 澶嶅埗浠ヤ笂浠ｇ爜锛屾墦寮excel鏂囦欢锛屾寜alt+F11閿紝鍦ㄤ笂鏂硅彍鍗曚腑閫夋嫨鎻掑叆妯″潡锛岀矘璐磋浠ｇ爜锛屾寜F5杩愯鍗冲彲銆
绛旓細C2杈撳叆浠ヤ笅鏁扮粍鍏紡锛屾寜Ctrl+Shift+Enter缁勫悎閿粨鏉燂紝鐒跺悗鍚戜笅濉厖鍏紡 =MIN(IF(B2<OFFSET(F$1:I$1,MATCH(A2,E$2:E$4,0),),OFFSET(F$1:I$1,MATCH(A2,E$2:E$4,0),)))璇﹁闄勫浘绀轰緥
绛旓細鍒嗕袱姝ヨ繘琛岋細1锛屽鏋滄暟鎹粠a1寮濮锛岄偅涔堝湪c1杈撳叆鍏紡锛=if(countif锛坆:b,a1)>0锛"",a1)鍚戜笅濉厖銆2锛屽鍒禼鍒楀湪c鍒楃矘璐存暟鍊硷紝浣跨敤鑿滃崟宸ュ叿鍒犻櫎绌哄煎崟鍏冩牸锛岀Щ鍒颁笂闈㈠嵆鍙備互涓鐨c鍒楁暟鎹氨鏄痑鍒楁湁b鍒楁病鏈夌殑銆
绛旓細sub test锛堬級hh=3 do while cells锛坔h锛2锛<>"" AND CELLS(HH,2)<>DATE HH=HH+1 LOOP IF CELLS(HH,2)="" THEN MSGBOX ("娌℃湁鎵惧埌")ELSE '鎵惧埌鍚庯紝璇ュ仛鍟ュ氨鍋氬暐 end if end sub
绛旓細鎶1-5銆6-10...褰撴垚璁＄畻鍏紡鏉ュ鐞嗗氨濂戒簡銆=ABS(EVALUATE(D5))+1 EVALUATE锛圖5)灏辨槸鎶1-5鍙樻垚浜=1-5锛岀粨鏋滄槸-4锛孉BS鏄緱鍑虹粷瀵瑰硷紝鏈鍚庡啀+1灏辨槸鎬婚〉鏁般
