Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
16 - Nebula
16 - Nebula

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