Formula for Dates & Status

Platform discussions Special workflows & use cases
, ,
1

Hi!

I’m trying to create a formula for astrological signs.
For example:
If the date falls between 3/21-4/19, status is set to Aries. OR If the date falls between 4/20-5/20, status is set to Taurus. ETC

Basically so I can get all the astrological signs attached to employee birthdays and have the Astrology sign status column to automatically assign based on their birthday column.

I’m much better at formulas in Excel, but formulas in Monday are somehow confusing to me.
Can someone help me with how that would look?

3

Hi @kayla05110415,

Try:

IF(FORMAT_DATE({Date},"MMDD")>"1221","Capricorn",
IF(FORMAT_DATE({Date},"MMDD")>"1121","Sagittarius",
IF(FORMAT_DATE({Date},"MMDD")>"1023","Scorpio",
IF(FORMAT_DATE({Date},"MMDD")>"0922","Libra",
IF(FORMAT_DATE({Date},"MMDD")>"0822","Virgo",
IF(FORMAT_DATE({Date},"MMDD")>"0722","Leo",
IF(FORMAT_DATE({Date},"MMDD")>"0621","Cancer",
IF(FORMAT_DATE({Date},"MMDD")>"0520","Gemini",
IF(FORMAT_DATE({Date},"MMDD")>"0419","Taurus",
IF(FORMAT_DATE({Date},"MMDD")>"0320","Aries",
IF(FORMAT_DATE({Date},"MMDD")>"0218","Pisces",
IF(FORMAT_DATE({Date},"MMDD")>"0119","Aquarius",""))))))))))))