# Formula to determine the season we're in

I want to make formula that tells you in what Season we are. I have the seasons divided as follows:

• Summer = July-Oct
• Spring = Mar-June
• Winter = Nov-Feb

I have a column which shows the number of the month we’re in with help of the formula `MONTH(TODAY())`

Then in the column next to it I made a nested IF statement which should determine which the season we’re in based on the division I set above, but it’s only showing the season ‘Summer’ when the month column has a number between 7 and 9 (July-September). With the other month numbers it show no result (i.e. a blank cell).

Here’s the IF statement I’m using:

``````IF(
{Current Month} >= 7,
IF({Current Month} <= 10, 'Summer',
IF({Current Month} >= 3,
IF({Current Month} <= 6, 'Spring',
IF({Current Month} >= 10,
IF({Current Month} <= 12,
IF({Current Month} >= 1,
IF({Current Month} <= 2, 'Winter')
)))))))
``````

It would be great if you could help me out. Thanks in advance.

Hi @Owen_Moss,
You can try this SWITCH formula to clean things up

``````SWITCH(
MONTH(TODAY()),
1, 'Winter',
2, 'Winter',
3, 'Spring',
4, 'Spring',
5, 'Spring',
6, 'Spring',
7, 'Summer',
8, 'Summer',
9, 'Summer',
10, 'Summer',
11, 'Winter',
12, 'Winter')
``````
2 Likes

Thank you. That worked.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.