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

gawa
15 - Aurora

Done

jdbaldwin
7 - Meteor

My solution is a little more general, though not fully generalized. And I just did a browse tool without bothering to put it in an Excel output file.

 

Still, I think it's worth looking at.

 

Spoiler
jdb_challenge_248_solution.jpg
mertshepard
8 - Asteroid

Solution attached.

alacoume
8 - Asteroid

My solution:

jpg34
8 - Asteroid

My solution

Spoiler
my solution screenshot.png

MDestra
8 - Asteroid

Challenge #248:

BenoitC
Alteryx
Alteryx

Done!

Spoiler
image.png
Benoit Conley

Sales Engineer
Alteryx, Inc.

Sanricson
5 - Atom

Hi all, I am new to Alteryx. Thank you for all the solutions, this is very useful. However, the dates seems to be prefix for year 2021. My current assignment is to calculate the number of business dates (exclude holidays and weekends) between any 2 given dates from an excel file. However, there will be scenario where 1 or both of the dates may be null in the excel. If this happen, it is not require to calculate the business days. Appreciate your help as my assisgnment is end of this week. Thank you

networkmike42
8 - Asteroid
Spoiler
Screenshot 2023-10-30 165517.png

emily_cummings
6 - Meteoroid

Solution: