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 #258: Relatively Old

OllieClarke
15 - Aurora
15 - Aurora

@PhilipMannering why do you think Kevin is younger?

LHolmes
9 - Comet

@OllieClarke 

@PhilipMannering 

 

I'm going to guess it has to do with DateTimeAdd subtraction syntax appearances.

PhilipMannering
16 - Nebula
16 - Nebula

@OllieClarke - because I had a brain-fart. 

@LHolmes  - you are correct, sir.

phottovy
13 - Pulsar
13 - Pulsar

Instead of individual formulas, I decided to go with an iterative macro that lets you set up all the formulas at the beginning:

Spoiler
Workflow:
258.PNG

Macro:
258_Macro.PNG

Formulas Table:
258_Formulas_Table.PNG
abrouwer
8 - Asteroid

Solution attached

SWalker
7 - Meteor

Don't sleep on DateTime functions. 

dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1615241080610.png

 

rcarog
8 - Asteroid

Solution attached.

jacob_kahn
12 - Quasar

Great challenge! Love Date and Time!

 

the_jake_tool

#itsanalyticsyo

 

https://www.linkedin.com/in/jacob-kahn-/

 

 

 

 

Qiu
20 - Arcturus
20 - Arcturus

Nice one for a morning to start

Spoiler
challenge_258.PNG