Thank you so much the only one not working is the summer
I have =IF(AND(MONTH(H3)4,(H3)<9),"Summer","") reading from
05/15/08 12:00 AM
and it doesnt return anything


"Jim Cone" wrote:


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?