一公式 分別取年月日與代号 (11232)

D2=TEXT(B$3,CHOOSE(ROW(A1),"YYY","M","D"))*1

E2=LOOKUP(D2,OFFSET(G$1:H$1,,ROW(A1)*2-2,31))

B1=E1&E2&E3&E4