• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get zodiac sign of a birth date using Excel 2007 Macro?

Momir

New Member
I need to select a colum in excel that contains birth dates and using a Macro (that I don't have at the moment) replace them with zodiac signs. Does anyone have a Macro like that? :cool:

Jut to remember:

Zodiac Sign Date
Aries March 21 - April 19
Taurus April 20 - May 20
Gemini May 21 - June 20
Cancer June 21 - July 22
Leo July 23 - August 22
Virgo August 23 - September 22
Libra September 23 - October 22
Scorpio October 23 - November 21
Sagittarius November 22 - December 21
Capricorn December 22 - January 19
Aquarius January 20 - February 18
Pisces
February 19 - March 20
 
Back
Top