Help with formula/script/etc for assigning Zodiac sign to birthdays
I’m not very tech-friendly, so I’m not sure what the best way to go about this request would be - any advice is very much appreciated!
I keep all of my orders in a table - each individual birthdate is imported with each order in its own column (DOB). I would like to find a solution to automatically update a separate column (ZODIAC) with the corresponding Zodiac sign depending on the day/month of birth.
I can’t seem to make it an automation in Airtable with if/then parameters because I can’t select a date range without the Year included.
Does this make sense? Any tips?
Thanks in advance!
To elaborate a bit on how the formula works – the idea is to split each month in two and assign a sign to each part. For example, January 1 to 19 is Capricorn and the rest of January is Aquarius.
To elaborate a bit on how the formula works – the idea is to split each month in two and assign a sign to each part. For example, January 1 to 19 is Capricorn and the rest of January is Aquarius.
@Raminder_Singh
Raminder, I should have known I could count on you!!
Thank you so much. :slightly_smiling_face:
To elaborate a bit on how the formula works – the idea is to split each month in two and assign a sign to each part. For example, January 1 to 19 is Capricorn and the rest of January is Aquarius.
Since the day will always be at least one, the formula can be tightened up a bit: