公式如下
=IF(LEN(A2)=18,CHOOSE(MATCH(TRUE,MID(A2,11,2)&"月"&MID(A2,13,2)&"日">={"12月22日","11月22日","10月23日","09月23日","08月23日","07月23日","06月22日","05月21日","04月21日","03月21日","02月19日","01月20日"},),"摩羯座","射手座","天蝎座","天秤座","处女座","狮子座","巨蟹座","双子座","金牛座","白羊座","双鱼座","水瓶座"),CHOOSE(MATCH(TRUE,MID(A2,9,2)&"月"&MID(A2,11,2)&"日">={"12月22日","11月22日","10月23日","09月23日","08月23日","07月23日","06月22日","05月21日","04月21日","03月21日","02月19日","01月20日"},),"摩羯座","射手座","天蝎座","天秤座","处女座","狮子座","巨蟹座","双子座","金牛座","白羊座","双鱼座","水瓶座"))
