①.将日期转成字符串
TEXT(C2,“YYYY-MM-DD”)------E2
②.对最后一个字符替换
=SUBSTITUTE(E2,"-","@",LEN(E2)-LEN(SUBSTITUTE(E2,"-","")))----F2
③.截取两个字符键=之间的字符串
=MID(F2,FIND("(",F2)+1,FIND(")",F2)-FIND("(",F2)-1) ---- B2
–综合一步到位的处理–B2
=MID(SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-","@",LEN(TEXT(C2,“YYYY-MM-DD”))-LEN(SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-",""))),
FIND("-",SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-","@",LEN(TEXT(C2,“YYYY-MM-DD”))-LEN(SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-",""))))+1,FIND("@",SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-","@",LEN(TEXT(C2,“YYYY-MM-DD”))-LEN(SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-",""))))
-FIND("-",SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-","@",LEN(TEXT(C2,“YYYY-MM-DD”))-LEN(SUBSTITUTE(TEXT(C2,“YYYY-MM-DD”),"-",""))))-1)