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?
.


.