C2=MID(LEFT(B2,10)&"/"&LEFT(B2,10),7,10)
D2=TEXT(SUM(MID(B2,{7,1,4},{4,2,2})*10^{4,2,0}),"0!/00!/00")
C8=TEXT(TEXT(SUM(MID(SUBSTITUTE(LEFT(B8,FIND(" ",B8&" ")-1),"/",REPT(" ",99)),{3,1,2}*99-98,99)*10^{4,2,0}),"0-00-00"),"YYY/M/D")
C8=TEXT(-LOOKUP(1,-LEFT(MID(B8,LOOKUP(1,0/(MID(B8,ROW($1:$9),1)="/"),ROW($1:$9))+1,4)&"/"&B8,ROW($1:$10))*1),"YYY/M/D")
留言
張貼留言