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

binay2448
11 - Bolide

My Solution...

Sankalp_Neelakantappa_0-1629860322923.png

 

mzajac
7 - Meteor

At least two solutions I can think of, with using Multi-Row Formula being more elegant and faster.

 

 

mzajac_0-1630074266958.png

 

MichaelPilotFreight
8 - Asteroid

Check out my solution!

brandowd
8 - Asteroid

Hi @GeneR,

 

I used an additional lookup table for the months and then had to rethink a bit when I got to the lovely "J" = June / July moment.

Spoiler
brandowd_0-1631088296458.png

 

msalem
7 - Meteor

my solution 

simon_inviso
8 - Asteroid

My solution (Spoiler)

tusharpl
7 - Meteor

test

tusharpl
7 - Meteor

solved

pfaigmani
7 - Meteor

My solution to challenge #21