Notion Formula: Return The Zodiac From A Date
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", "")))))))))))))