We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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 @TC_bot - 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
15 - Aurora
15 - Aurora
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
15 - Aurora
15 - Aurora
Spoiler
248.png
sara_burk
7 - Meteor

Happy Holidays!

Jason_Fruh
5 - Atom

Happy Holidays!

 

Spoiler
Jason_Fruh_1-1609177476379.png

 

 

atcodedog05
17 - Castor

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