Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #252: Working Days Remaining

AYXAcademy
Alteryx
Alteryx

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

 

This week's challenge was submitted by @NapasornCh  - Thanks for your submission!

 

Everyone has deadlines in business so it's natural to wonder how many working days you have left before time is up!

 

This week's challenge is to create a macro to calculate the number of business days between two user-selected dates, excluding both weekends and any dates specified by an optional input file. The included input file contains US holidays for 2021, as well as a few vacation days. Your macro should also allow the end-user to select the starting and ending date for the period.

Aaron_Harter
11 - Bolide

I'm already counting the days until the next holiday!

Spoiler
1.1.PNG
Macro configuration:
1.2.PNG

 

DaisukeTsuchiya
13 - Pulsar
Spoiler
I created Analytic App with Macro. I think starting date is between Jan 23 to 25 not Jan 19 in sample output.

キャプチャ.JPG

キャプチャ2.JPG

 

 

DeanWest
9 - Comet

Looking forward to the next holiday!

 

Spoiler
challenge_252_solution_DeanWest-snippet_1.png
Spoiler
challenge_252_solution_DeanWest-snippet_2.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1611588807055.png

 

clmc9601
13 - Pulsar
13 - Pulsar

@AYXAcademy, the output looks like it was configured to 1/25/21, not 1/19/21 as mentioned in the workflow instructions 🙂

 

Spoiler
Screen Shot 2021-01-25 at 8.47.29 AM.png
ggruccio
ACE Emeritus
ACE Emeritus

Fun with macros!  I often equate interfaces with apps, but this works too!  

 

ggruccio_1-1611589779927.png

Spoiler
Created start date and end date user inputs, used to generate rows.  Then used a formula to get to day of week....filtered out Saturday and Sunday.  Then created detour logic with check box interface for whether or not to include the optional file.

ggruccio_2-1611589879965.png

 

phottovy
13 - Pulsar
13 - Pulsar

Good way to start the week!

 

Spoiler
252.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler

 

Kenda_0-1611590847073.png

 


 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
252.png252I.png