Excel Formula to get Season name?

Question

My Task is to get Season name from Date in Excel using a formula.

So far I achieved getting Month name from Date thanks to this link:

http://dedicatedexcel.com/how-to-convert-a-date-into-a-month-name-in-excel-2010/

Is there anyway (like switch-case) in Excel formulas so I can get Season name based on month name?

Thanks.

Answer 1

You can use the Choose() function for that. When exactly a season starts may be open to debate. This formula assumes that the season starts at the first of the month, not the solstice and equinox days.

The formula for the Northern Hemisphere in B2 is

=CHOOSE(MONTH(A2),"Winter","Winter","Spring","Spring","Spring","Summer","Summer","Summer","Autumn","Autumn","Autumn","Winter")

The formula for the Southern Hemisphere in C2 is

=CHOOSE(MONTH(A2),"Summer","Summer","Autumn","Autumn","Autumn","Winter","Winter","Winter","Spring","Spring","Spring","Summer")

If you want the seasons to begin at the solstice and equinox dates, then use this for Northern hemisphere:

=IF(DAY(A2)<22,CHOOSE(MONTH(A2),"Winter","Winter","Winter","Spring","Spring","Spring","Summer","Summer","Summer","Autumn","Autumn","Autumn","Winter"),CHOOSE(MONTH(A2),"Winter","Winter","Spring","Spring","Spring","Summer","Summer","Summer","Autumn","Autumn","Autumn","Winter"))