Date is in cell B5...

=IF(MONTH(B5)8,"Fall","")
=IF(MONTH(B5)<5,"Spring","")
=IF(AND(MONTH(B5)4,MONTH(B5)<9),"Summer","")
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Cazumel"
wrote in message
Here is my scenario

Semester Fall Spring Summer

10/17/07 12:00 AM Fall
04/01/07 12:00 AM Spring
09/01/07 12:00 AM
09/01/07 12:00 AM
09/01/07 12:00 AM
09/01/07 12:00 AM
How do I create a formula that can recognize the date and return the season
under the proper season colum?