Student Roster - fall, spring,summer, winter?

[Cazumel]

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?

 

[Jim Cone]

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?

 

[Cazumel]

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

 

[Cazumel]

i KNOW WHAT i WAS DOING WRONG FORGOT THE MONTH....
THANK YOU SO MUCH I CAN SLEEP IN PEACE NOW...NEED THIS FOR WORK TOMORROW

 

[Cazumel]

thank you I have an answer

How do you define your seasons?

 

[T. Valko]

Combining them all into a single formula:

=LOOKUP(MONTH(B5),{1,5,9},{"Spring","Summer","Fall"})

 

[Cazumel]

You peole are so cool...thank you,
can you help me with the other question ...select particular ..I have
another post there