Here are the dates:
Aries - 3/21 - 4/19
Pisces - 2/19 - 3/20
Taurus - 4/20 - 5/20
Gimini - 5/21 - 6/21
Cancer - 6/22 - 7/22
Leo - 7/23 - 8/22
Virgo - 8/23 - 9/22
Libra - 9/23 - 10/22
Scorpio - 10/23 - 11/21
Sagittarius - 11/22 - 12/21
Capricorn - 12/22 - 1/19
Aquarius - 1/20 - 2/18

Thank you so much for helping :)

"Biff" wrote:

Well actaully i was thinking about all 12 of them...

Yeah, I kind of figured that! <g

Well, I don't know all the dates or the other signs.

Biff

-----Original Message-----
Well actaully i was thinking about all 12 of them...
is that possible?

"Biff" wrote:

Hi!

If all you want to check for is those two and the date
is
entered in A1:

A1 = date

=IF(AND(A1=DATE(YEAR(TODAY()),3,21),A1<=DATE(YEAR (TODAY
()),4,19)),"Aries",IF(AND(A1=DATE(YEAR(TODAY
()),7,23),A1<=DATE(YEAR(TODAY()),8,22)),"Leo",""))

If you want all 12 then a different approach will be
needed.

Biff

-----Original Message-----
If dates are 3/21 to 4/19 = Aries
and if dates are 7/23 to 8/22 = Leo

How do I make a valid excel formula?
.


.