Zodiac Formula

Master Tag
Fun
Created
Jun 18, 2020 04:34 PM
Usage
Greater Than
Less Than
Month
Date
Web Tags
Formula
Alternatives
Cover
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", "")))))))))))))
What you need: Date property named “Born”
 
Zodiac Formula
Name
Born
Zodiac
Apr 21, 1926
Jan 17, 1964
Aug 11, 1994