Hello,
I'm brand new to excel. I'm trying to build a excel program that allows me to enter any date from 1920-2012, and receive the corresponding zodiac sign including cusps.
example:
January 20, 1992 = Capricorn-Aquarius Cusp
January 26, 1934 = Aquarius
The tricky part is that these signs dates change each year, due to the sun entering the sign on different days each year. I digress.
Is this possible?
Here's a sample list of data:
1920
January 22- Sun goes into Aquarius
February 20- Sun goes into Pisces
March 21- Sun goes into Aries
April 21- Sun goes into Taurus
May 22- Sun goes into Gemini
June 22- Sun goes into Cancer
July 24- Sun goes into Leo
August 24- Sun goes into Virgo
September 24- Sun goes into Libra
October 24- Sun goes into Scorpio
November 23- Sun goes into Sagittarius
December 23- Sun goes into Capricorn
1921
January 21- Sun goes into Aquarius
February 20- Sun goes into Pisces
March 22- Sun goes into Aries
April 21- Sun goes into Taurus
May 22- Sun goes into Gemini
June 22- Sun goes into Cancer
July 24- Sun goes into Leo
August 24- Sun goes into Virgo
September 24- Sun goes into Libra
October 24- Sun goes into Scorpio
November 23- Sun goes into Sagittarius
December 23- Sun goes into Capricorn
1922
January 21- Sun goes into Aquarius
February 20- Sun goes into Pisces
March 22- Sun goes into Aries
April 21- Sun goes into Taurus
May 22- Sun goes into Gemini
June 23- Sun goes into Cancer
July 24- Sun goes into Leo
August 24- Sun goes into Virgo
September 24- Sun goes into Libra
October 25- Sun goes into Scorpio
November 24- Sun goes into Sagittarius
December 23- Sun goes into Capricorn
1923
January 22- Sun goes into Aquarius
February 20- Sun goes into Pisces
March 22- Sun goes into Aries
April 22- Sun goes into Taurus
May 23- Sun goes into Gemini
June 23- Sun goes into Cancer
July 24- Sun goes into Leo
August 25- Sun goes into Virgo
September 25- Sun goes into Libra
October 25- Sun goes into Scorpio
November 24- Sun goes into Sagittarius
December 23- Sun goes into Capricorn
Also, a cusp sign is +/- 3 days. So a Sagittarius-Capricorn in 1923 would be December 20-26, 1923. Sagittarius 1923 would be November 28-December 19.
Thanks a lot for any help!
P.S. I don't know if this is correct astrology, but this is how the project is supposed to be done.
Bookmarks