Formula to determine the Zodiac sign

[mgana]

I need a formula (no VBA) that will display the name of the zodiac sign in column B based on the date of birth (dd/mm/yyyy) entered in column A according to the following criteria:

Dec. 22 - Jan. 19 - Capricorn
Jan. 20 - Feb. 17 - Aquarius
Feb. 18 - Mar. 19 - Pisces
March 20 - April 19 - Aries
April 20 - May 19 - Taurus
May 20 - June 20 - Gemini
June 21 - July 21 - Cancer
July 22 - Aug. 22 - Leo
Aug 23 - Sept. 21 - Virgo
Sept. 22 - Oct. 22 - Libran
Oct. 23 - Nov. 21 - Scorpio
Nov. 22 - Dec. 21 - Sagittarius

Can this be done?

 

[Peter_SSs]

-- is not the problem. Have you tried the formula from post #27?

 

[Carel Smith]

As I explained when using the double - I get a value error, in other words while I try to force the text value to convert to a number value using text formula with the "--" I get an error

=--TEXT (A1,"m.dd")
Results = #VALUE

I found the problem