本文向给大家分享输入生日查询星座相关知识，同时小编也会对免费测试自己真正星座进行解释，如果能解决您在输入生日查询星座方面面临的问题，请收藏关注本站，现在开始吧！
=if(if(len(a1)=15,date(1900,mid(a1,9,2),mid(a1,11,2)),date(1900,mid(a1,11,2),mid(a1,13,2)))<21,"魔羯座",index({"水瓶座","双鱼座","牧羊座","金牛座","双子座","巨蟹座","狮子座","处女座","天秤座","天蝎座","射手座","魔羯座"},match(if(len(a1)=15,date(1900,mid(a1,9,2),mid(a1,11,2)),date(1900,mid(a1,11,2),mid(a1,13,2))),{21,51,81,112,143,174,206,237,268,297,328,357},1)))
以上假设身份证在单元格a1，公式太长了，可以考虑在b1输入 =if(len(a1)=15,date(1900,mid(a1,9,2),mid(a1,11,2)),date(1900,mid(a1,11,2),mid(a1,13,2)))
再c1输入 =if(b1<21,"魔羯座",index({"水瓶座","双鱼座","牧羊座","金牛座","双子座","巨蟹座","狮子座","处女座","天秤座","天蝎座","射手座","魔羯座"},match(b1,{21,51,81,112,143,174,206,237,268,297,328,357},1)))
结果在c1