Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Formula to determine the season we're in

Topic Labels: Formulas
Solved
Jump to Solution
164 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

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')

See Solution in Thread

2 Replies 2

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')

Thank you. That worked.