Fortune Telling Collection - Zodiac Guide - Excel, knowing the ID number, wants to set the corresponding constellation through the date of birth.
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.
- Related articles
- What does the word on the stamp mean?
- Four constellations that always leave a handsome back when dragging into the sky.
- Constellation mismatch _ What if the constellation mismatch?
- What constellation likes to collect things?
- Inspirational story of youth struggle
- The 2022 fortune of a Capricorn girl.
- Which constellations will be sleepy in the afternoon?
- What constellation cloak does the Rainbow Island Musketeer use?
- Lunar Constellation Query: What constellation is the fifteenth day of the first lunar month?
- Who is the top water bottle and who is the top Gemini?