Assign category based on date range with IF()

Topic Labels: Formulas
499 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0