占用天数 (9175)

E2{=IF(C2,A2-OFFSET(A$1,MATCH(1=1,(B$2:B2>0)*SUBTOTAL(9,OFFSET(B$2,,,ROW($1:1)))>=SUM(C$2:C2),),),"")

F2{=IF(C2,TEXT(A2-OFFSET(A$1,MATCH(1=1,SUM(C$1:C1)<IF(B$2:B2,SUBTOTAL(9,OFFSET(B$2,,,ROW($1:1))),),),),"[<>"&E2&"]0;"),"")