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 #46: Formatting a Date from an Integer

ferg_smith
8 - Asteroid
Spoiler
ferg_smith_0-1678197774028.png

 

syahya
8 - Asteroid
Spoiler
46 Solution.PNG

I didn't like the one formula tool solution with the date expressions, so I split it into separate steps.

jerviss53
8 - Asteroid

Solution attached

CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1678289403929.png
bajajankit
7 - Meteor

a little long method

michael_apau
8 - Asteroid

Screenshot 2023-03-10 140830.png

JClinton
7 - Meteor
Spoiler
Spoiler 

Jessshaver_0-1678822602469.png

 

asimmonz9076
7 - Meteor

Done.

mindyzhang99
8 - Asteroid

Two approaches but same logic

I prefer the first one as the logic is more clear

The second one is more efficient

mindyzhang99_1-1679114269062.png

mindyzhang99_2-1679114460216.png

 

mindyzhang99_3-1679114576426.png

 

 

 

 

aashijain7
5 - Atom

simple solution