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 #248: Holidates

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereChallenge248.png

 

This week's challenge was submitted by @Tony_Castillo - Thank you for your submission!

 

Looking to the new year (2021), we want to produce a log for our staff showing workdays for the upcoming year. 2 employees follow the US holiday schedule and 1 employee follows the Australian (Victoria) holiday schedule. Produce an Excel file showing the business days with holidays for all 3 employees.

 

Bonus: How many US and Australian business days are there in 2021?

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1609164951847.png

 


 

Aaron_Harter
11 - Bolide

Happy Holidays!

Spoiler
2.PNG
Blake
12 - Quasar

Happy Holidays! 

 

Spoiler
248.3.png250 US Business days and 251 AUS Business days for the bonus. 

 See below for a video walkthrough of this challenge.

 

Spoiler

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
248.png
sara_burk
7 - Meteor

Happy Holidays!

JasonFruh
5 - Atom

Happy Holidays!

 

Spoiler
Jason_Fruh_1-1609177476379.png

 

 

atcodedog05
22 - Nova
22 - Nova

Fun and easy challenge 

 

Spoiler
atcodedog05_0-1609178407748.png

 

Cheers and Happy Analyzing 😀

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1609183545125.png

 

Spalders
8 - Asteroid
Spoiler
Spalders_0-1609186330038.png