The Formula
if(month(prop("Born")) < 1 and date(prop("Born")) < 21, "♑️ Capricorn", if(month(prop("Born")) < 1 and date(prop("Born")) > 20 or month(prop("Born")) < 2 and date(prop("Born")) < 20, "♒️ Aquarius", if(month(prop("Born")) < 2 and date(prop("Born")) > 19 or month(prop("Born")) < 3 and date(prop("Born")) < 21, "♓️ Pisces", if(month(prop("Born")) < 3 and date(prop("Born")) > 20 or month(prop("Born")) < 4 and date(prop("Born")) < 21, "♈️ Aries", if(month(prop("Born")) < 4 and date(prop("Born")) > 20 or month(prop("Born")) < 5 and date(prop("Born")) < 21, "♉️ Taurus", if(month(prop("Born")) < 5 and date(prop("Born")) > 19 or month(prop("Born")) < 6 and date(prop("Born")) < 22, "♊️ Gemini", if(month(prop("Born")) < 6 and date(prop("Born")) > 21 or month(prop("Born")) < 7 and date(prop("Born")) < 23, "♋️ Cancer", if(month(prop("Born")) < 7 and date(prop("Born")) > 22 or month(prop("Born")) < 8 and date(prop("Born")) < 24, "♌️ Leo", if(month(prop("Born")) < 8 and date(prop("Born")) > 23 or month(prop("Born")) < 9 and date(prop("Born")) < 24, "♍️ Virgo", if(month(prop("Born")) < 9 and date(prop("Born")) > 23 or month(prop("Born")) < 10 and date(prop("Born")) < 24, "♎️ Libra", if(month(prop("Born")) < 10 and date(prop("Born")) > 23 or month(prop("Born")) < 11 and date(prop("Born")) < 23, "♏️ Scorpio", if(month(prop("Born")) < 11 and date(prop("Born")) > 22 or month(prop("Born")) < 12 and date(prop("Born")) < 22, "♐️ Sagittarius", if(month(prop("Born")) < 12 and date(prop("Born")) > 21, "♑️ Capricorn", "")))))))))))))
The Formula Breakdown
Zodiac | Formula Section | |
---|---|---|
Capricorn | 1/1-1/20 | if(month(prop("Born")) < 1 and date(prop("Born")) < 21, "♑️ Capricorn", |
Aquarius | 1/21-2/19 | if(month(prop("Born")) < 1 and date(prop("Born")) > 20 or month(prop("Born")) < 2 and date(prop("Born")) < 20, "♒️ Aquarius", |
Pisces | 2/20-3/20 | if(month(prop("Born")) < 2 and date(prop("Born")) > 19 or month(prop("Born")) < 3 and date(prop("Born")) < 21, "♓️ Pisces", |
Aries | 3/21-4/20 | if(month(prop("Born")) < 3 and date(prop("Born")) > 20 or month(prop("Born")) < 4 and date(prop("Born")) < 21, "♈️ Aries", |
Taurus | 4/21-5/20 | if(month(prop("Born")) < 4 and date(prop("Born")) > 20 or month(prop("Born")) < 5 and date(prop("Born")) < 21, "♉️ Taurus", |
Gemini | 5/21-6/21 | if(month(prop("Born")) < 5 and date(prop("Born")) > 19 or month(prop("Born")) < 6 and date(prop("Born")) < 22, "♊️ Gemini", |
Cancer | 6/22-7/22 | if(month(prop("Born")) < 6 and date(prop("Born")) > 21 or month(prop("Born")) < 7 and date(prop("Born")) < 23, "♋️ Cancer", |
Leo | 7/23-8/23 | if(month(prop("Born")) < 7 and date(prop("Born")) > 22 or month(prop("Born")) < 8 and date(prop("Born")) < 24, "♌️ Leo", |
Virgo | 8/24-9/23 | if(month(prop("Born")) < 8 and date(prop("Born")) > 23 or month(prop("Born")) < 9 and date(prop("Born")) < 24, "♍️ Virgo", |
Libra | 9/24-10/23 | if(month(prop("Born")) < 9 and date(prop("Born")) > 23 or month(prop("Born")) < 10 and date(prop("Born")) < 24, "♎️ Libra", |
Scorpio | 10/24-11/22 | if(month(prop("Born")) < 10 and date(prop("Born")) > 23 or month(prop("Born")) < 11 and date(prop("Born")) < 23, "♏️ Scorpio", |
Sagittarius | 11/23-12/21 | if(month(prop("Born")) < 11 and date(prop("Born")) > 22 or month(prop("Born")) < 12 and date(prop("Born")) < 22, "♐️ Sagittarius", |
Capricorn | 12/22-12/31 | if(month(prop("Born")) < 12 and date(prop("Born")) > 21, "♑️ Capricorn", |