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 #10: Date Time Calculations

Steph_Maddrell
8 - Asteroid

Nice challenge, though my formulas aren't quite as elegant as some of the other solutions

 

Spoiler
Steph_Maddrell_0-1623599051195.png 

 

j_trefethen
8 - Asteroid
Spoiler
Challenge 10 - JT solution.jpg

JasonTylerYoung
8 - Asteroid
Spoiler
Well now I know what the MOD function does
Pmago89
7 - Meteor

Here is the solution I went with

Pmago89
7 - Meteor

Here is my solution 

Ajjay
8 - Asteroid

Soln

Erin
9 - Comet

Submission attached

cherrington
7 - Meteor

Result shown in "output" box in the start file is not correct.  The solution workflow has the correct result.  

EFos
8 - Asteroid
Spoiler
EFos_0-1625459389713.png

 

Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1625501098820.png

Lots of DATETIMEDIFF!