Free Trial

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

anshuverma0912
8 - Asteroid

Hi, Here is my solution!!

LukasJennings
8 - Asteroid
Spoiler
Weekly Challenge 21 Solved.jpg

 

xxreese
8 - Asteroid

I got it in perhaps a round about way

alexnajm
18 - Pollux
18 - Pollux

Done! A little bit of a different way...

simbert
8 - Asteroid

Slightly lengthy solution to avoid having to write a really long if statement

Spoiler
simbert_0-1601395293335.png

 

gokhane
7 - Meteor

the hard way...

LGFAnalyst
6 - Meteoroid

The second multi-row formula really stumped me, I was excited to find a use for the multi-row formula's "fill down", but had no idea how to do the month assignment. 

 

Thanks for the challenge!

DeanWest
9 - Comet

This was fun! I incorporated a simple use of the Tile Tool in my solution below:

 

Spoiler
challenge_21_Solution-DeanWest_snippet.PNG
DataNexus
7 - Meteor

Nothing special about my response.

OwenBData
8 - Asteroid

My solution!:

Spoiler
Challenge 21.PNG