Student Roster - fall, spring,summer, winter?

  • Thread starter Thread starter Cazumel
  • Start date Start date
C

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?
 
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?
 
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
 
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
 
Combining them all into a single formula:

=LOOKUP(MONTH(B5),{1,5,9},{"Spring","Summer","Fall"})
 
You peole are so cool...thank you,
can you help me with the other question ...select particular ..I have
another post there
 
Back
Top