4 seasons of date ranges - evaluate dates in which season?

I have a list of dates, and I need to find out which season each one falls in. From all of the date researching that I have done, I cannot seem to get my answer.

Here is the issue. I have a list of dates:

1/24/02
5/14/03
7/11/02
8/3/05
etc

Then I have 4 seasons, which are the same every year, so year is not included. They are as follows:

A = 10/25 - 4/30
B = 5/01 - 7/24
C = 7/25 - 9/05
D = 9/06 - 10/24

So for each date, I need to see if it equals A, B, C or D.... Any thoughts? I have tried this a number of ways, including trying to split them up, and using Month() and Day() functions, but everything comes back invalid. I hope some can see what I am not seeing!

Thank you,

Maybe this link can get you started ? http://www.cpearson.com/excel/DateIntervals.htm

Thank you! That was exactly what I needed. It will be nested quite a bit, but this will get me where I need to go. My other side issue is that when I complete the formula, even though it is successful in the formula box, it just sits as a formula in the cell when I exit. I have pressed CTRL accent (`), I have gone to tools | Options (excel 03) and to the calculation tab to ensure that the automatic option is chosen. What can I do? I think I have had this issue before. It is quite frustrating!

Thank you,

You don't really need a nested formula, if your date is in A1 try this to give the period, works regardless of year

=LOOKUP(TEXT(A1,"mmdd"),{"0101","0501","0725", "0906","1025";"A","B","C","D","A"})

If your formula shows as text probably the column is text-formatted - to convert try this:

Select column and use Data > Text to Columns > Finish