生日找 屬相 星座 (14597)

C2=TEXT(TEXT(B2,"0!/00!/00")*1,"YYY年M月D日生")

D2=MID("鼠牛虎兔龍蛇馬羊猴雞狗豬",MOD(LEFT(B2,4)-4,12)+1,1)

E2=MID("摩羯水瓶双鱼白羊金牛双子巨蟹狮子處女天秤天蝎射手摩羯",LOOKUP(RIGHT(B2,4)*1,{101,120,219,321,420,521,622,723,823,923,1024,1123,1222},ROW($1:$13))*2-1,2)&"座"