日期非正式 改可計算日期 (14375)

日期固定10字元 C2=TEXT(SUM(MID(B2,{7,4,1},{4,2,2})*10^{4,2,0}),"00!/00!/00")

日期不固定字元 C2=TEXT(SUM(MID(SUBSTITUTE(SUBSTITUTE(B2,"/"," ")," ",REPT(" ",99)),{3,2,1}*99-98,99)*10^{4,2,0}),"00!/00!/00")