Formula to identify the season of the year
Good afternoon; I would like to know if it is possible to create a formula to obtain the name of the season of the year related to a date; the idea is to be able to filter the seasons and set an anticipated schedule for the activities depending on the weather.
Best Answers
-
Try this:
=IF(OR([Date Column]@row>= DATE(YEAR([Planned Start Date]@row), mm, dd), [Date Column]@row<= DATE(YEAR([Planned Start Date]@row), mm, dd)), "Winter", IF([Date Column]@row<= DATE(YEAR([Planned Start Date]@row), mm, dd), "Spring", IF([Date Column]@row<= DATE(YEAR([Planned Start Date]@row), mm, dd), "Summer", "Fall")))
Just update each "mm" and "dd" to the appropriate month and day number for each season.
-
Awesome!!! This function is perfect; you are a rock star; thank you so much for your time in helping me with this.
Answers
-
Here is something we used for a basic one that is based on assigning a season to a Month rather than a specific date each year. Season Date column needs to be updated to whatever your column date is that you are referencing.
=IF(MONTH([Season Date]@row) >= 11, "Winter", IF(MONTH([Season Date]@row) >= 9, "Fall/Autumn", IF(MONTH([Season Date]@row) >= 6, "Summer", IF(MONTH([Season Date]@row) >= 4, "Spring", IF(MONTH([Season Date]@row) >= 1, "Winter")))))
-
Hi, thank you for responding to my question; that formula is good, but it is essential to include the day because, for example, Mach 21 will start the spring season, June 21 will start the summer season, September 21 will start the fall season and December 21 will start the winter season.
-
Are you able to provide a screenshot of how your sheet is set up?
-
Good morning; this is the sheet with which I work; you can see the highlighted cell the date 3/22/23 must be spring season, but with the formula posted, it shows like winter season; my goal is can filter the activities for the season; and to check the possible delay for the weather season.
-
Try incorporating the DATE function.
=IF(OR([Date Column]@row>= DATE(yyyy, mm, dd), [Date Column]@row<= DATE(yyyy, mm, dd)), "Winter", IF([Date Column]@row<= DATE(yyyy, dd, mm), "Spring", IF([Date Column]@row<= DATE(yyyy, mm, dd), "Summer", "Fall")))
You can make the DATE functions dynamic by replacing the hard coded year with the year from the date column.
DATE(YEAR([Date Column]@row), mm, dd)
-
I was proving the function you posted, but if you see the green highlight cell for this date, it is not winter season; I am trying to correct and incorporate another form; but I can't understand when you said, "You can make the DATE functions dynamic by replacing the hard coded year with the year from the date column." Could you please explain again? I appreciate your help.
DATE(YEAR([Date Column]@row), mm, dd)
-
Which column are you using to determine which season it is in?
-
Planned Start Date
-
Try this:
=IF(OR([Date Column]@row>= DATE(YEAR([Planned Start Date]@row), mm, dd), [Date Column]@row<= DATE(YEAR([Planned Start Date]@row), mm, dd)), "Winter", IF([Date Column]@row<= DATE(YEAR([Planned Start Date]@row), mm, dd), "Spring", IF([Date Column]@row<= DATE(YEAR([Planned Start Date]@row), mm, dd), "Summer", "Fall")))
Just update each "mm" and "dd" to the appropriate month and day number for each season.
-
Awesome!!! This function is perfect; you are a rock star; thank you so much for your time in helping me with this.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!