Tropical Zodiac Challenge with Excel formula!

posted Sep 25, 2012, 9:29 AM by r   [ updated Sep 25, 2012, 1:28 PM ]

Input: date of birth (A1)
Output: the sign of zodiac (tropical zodiac)

Try to do it without using a data table (to determine the signs) - so you should incorporate everything to one single formula.

Will you solution work with all possible date format?

Please post your formula and ideas here:
Excel Hero Linkedin Group

Puoi postare la tua formula in italiano o le tue idee qui:
NG Google Gruppi

Sep 25, 2012, 9:29 AM