B2=TEXT(SUM(TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",19)),{1,20},19))*{-1,1}),"[<0]"&MID(A2,FIND("-",A2)+1,9)-DAY(LEFT(A2,FIND("-",A2)-1))&";0")+1
D2{=IFERROR(TRIM(LEFT(SUBSTITUTE(INDEX(A:A,SMALL(IF(B$2:B$5>=COLUMN(A:Z),ROW($2:$5)),ROW(A1))),"-",REPT(" ",19)),19))+ROW(A1)-LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(B$1,,,ROW($1:$4))))-1,"")
留言
張貼留言