Skip to main content
Solved

Formula to determine the season we're in

O
Forum|alt.badge.img+3

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.

Best answer by Vivid-Squid

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')
View original
Did this topic help you find an answer to your question?

2 replies

V
Forum|alt.badge.img+16
  • Vivid-Squid
  • Inspiring
  • 532 replies
  • Answer
  • July 21, 2022

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')
TheTimeSavingCo
L
2 people like this
  • TheTimeSavingCo
    TheTimeSavingCo
  • L
    Luis_Marcelo_Ca
O
Forum|alt.badge.img+3
  • Owen_Moss
  • Author
  • New Participant
  • 2 replies
  • July 25, 2022

Thank you. That worked.

Reply


Most helpful members this week

Terms & Conditions