I am trying to have my airtable automatically assign someone a category based on the date range that their entry falls in.
Specifically, if someone’s birthday is within their zodiac sign dates, I want it to assign them that single select in the zodiac field.
For example, Aries is March 21- April 19th. If someone enters the form with the Birthday as April 1, I need it to add the single select of “Aries” to that record.
I know that this needs to be an IF() formula, but I am having troubling getting adding in the date without a year. If I have to make it with a year, then this field will have to be updated yearly, which isn’t the end of the world, I just need to know if there is a way to do a date range only using Days & Month.
Thanks in Advance!