轉化 起止日 平均數 剩餘放最後 (14468)

E2=IF(ROW(A1)>COUNT(C:C)*3,"",LOOKUP(1,0/(ROW(A3)/3>=ROW($1:$8))/(A$2:A$9>0),A$2:A$9))

F2:G23=IF($E2="","",DATE($E2,COUNTIF($E$2:$E2,$E2),DAY(EOMONTH(DATE($E2,COUNTIF($E$2:$E2,$E2),1),0))^(A$1=$B$1)))

H2=IF(E2="","",IF(MOD(ROW(A1),3),ROUNDUP(N(OFFSET(C$1,ROW(A3)/3,))/3,),N(OFFSET(C$1,ROW(A3)/3,))-H1*2))