How To Extract Season From Date in Excel

The easiest way is to use the CHOOSE function with the following formula:

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

Remember to replace the A2 with where the date is on your sheet.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *