Free Trial

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 #41: Analytics PayPeriodCalc

PrivateStorm
8 - Asteroid

My solution for challenge #41 is attached.

OllieClarke
15 - Aurora
15 - Aurora

Here's my solution:

Spoiler
challenge 41.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler
41.PNG
ivoller
12 - Quasar

Took too long on this one. Tried multiple methods before deciding generate rows worked ok for this example. I think for the real world I'd generate a lookup table for region, weekends, holidays etc.

schiang
7 - Meteor

Here is mine.

MarMu
8 - Asteroid

 

Always fun to play with networkdays. Extension of this exercise could be to include public holidays.

Couldn't get the same result untill I realized that 0 is sunday :)

 

Spoiler
challenge_41_start_file_MarMu.png
krishnapandey
7 - Meteor

here is solution for #41

soha-elghany
8 - Asteroid
Spoiler
spoiler

ch41.png
JoBen
11 - Bolide

Cheers!

Neetu
8 - Asteroid

my solution :)