Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #21: Date Reformatting

Raees09
8 - Asteroid

Solution

KristenB
7 - Meteor
Spoiler
I feel like there has to be a better way to rename the months other than a crazy if statement.
Bobbyt23
8 - Asteroid
Spoiler
Got caught out by the month rename then realised it needed to be a multirow formula.🤕
Ahmadhadji
5 - Atom

Challenge #21 - Solution 

I´ve used a different approach, to show how it can be solved in are more "Lehmann" approach. 

 

Enjoy

 

 

Raj
15 - Aurora

Solved!!

Solving challenges is always enjoyable and beneficial for skill development.

aatalai
14 - Magnetar

C21

leonardstarrk
8 - Asteroid

Also easy!

prabhakaran5
8 - Asteroid
Spoiler
Screenshot 2024-06-12 212026.png
Bren_Spill
12 - Quasar
Spoiler
image.png
Anee
7 - Meteor

Solved