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

This site uses Akismet to reduce spam. Learn how your comment data is processed.