Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi,
First I used a sequence of filter, datetime and formula to get the seasons. Used sort, filter and cross tab(average) to get the data followed by the formula to round it up. Fun challenge
Challenge 330 solution
This was brutal! Terribly vague, incomplete and imprecise instructions.
No way to figure out the final date of Fall and beginning date of Winter, if there's even a Winter.
I am no astrophysicist, but what sort of planet has a oblong triangular orbit that enables a 3 season year? Perhaps a 3 start planet like the '3 body problem'? :)
Anyway...