年月日取出 依日期 (11706)

C2:E9=INDEX(TEXT($B2,{"D","M","YYY"}),COLUMN(A1))

C1:E1 年月日可不固定=-LOOKUP(1,-MID(TEXT($B2,"YYY年M月D日"),FIND(C$1,TEXT($B2,"YYY年M月D日"))-{1,2,3,4},{1,2,3,4}))