How to use excel to calculate constellation _excel to calculate constellation

Excel, knowing the ID number, wants to set the corresponding constellation through the date of birth.

The formula is as follows

=IF(LEN(A2)= 18，CHOOSE(MATCH(TRUE，MID(A2， 1 1，2)& amp； "Month"&; MID(A2,13,2) and amp "day" > = {"65438+February 22nd", "165438+1October 22nd", "65438+ 10. "065438+1October 20th"},), "Capricorn", "Sagittarius", "Scorpio", "Libra", "Virgo", "Leo", "Cancer", "Gemini", "Taurus", "Aries" and ". MID(A2, 1 1, 2) and amp "day" > = {"65438+February 22nd", "165438+/October 22nd", "65438+/kloc-0". 065438+1October 20th},), Capricorn, Sagittarius, Scorpio, Libra, Virgo, Leo, Cancer, Gemini, Taurus, Aries and Capricorn.