C2=TEXT(CHOOSE(LOOKUP(FIND("/",B2&"/"),{3,4,5,6},{2,1,2,3}),-LOOKUP(1,-LEFT("R"&B2,ROW($1:$10))),-LOOKUP(1,-LEFT(B2,ROW($1:$10))),TEXT(-LOOKUP(1,-LEFT(B2,ROW($1:$10))),"0!/00!/00")*1),"YYY/MM/DD")
D2{=TEXT(IF(LEN(MAX(IFERROR(--RIGHT(B2,ROW($1:$10)),)))=5,MAX(IFERROR(--RIGHT(B2,ROW($1:$10)),)),TEXT(RIGHT(B2,6),"0!/00!/00")*1),"YYY/MM/DD")
留言
張貼留言