Challenge #252: Working Days Remaining

[Renato_7]

Spoiler

 

[SeanAdams]

Great use of Alteryx - Holiday planning!

I did something similar to @ggruccio and included an option for the file on the interface.

Spoiler

[MPard]

Spoiler

This was a great exercise for getting into Macros and User input. I only had an idea of how to use them but now I have some experience! I included my macro and the workflow that runs the interactive app using the macro.

EDIT: I updated the flow to display properly in the interactive app.

[Paulomi]

Fun exercise! 

[danicahui]

Spoiler

Macro with input option for holiday/leave dates:

[Maskell_Rascal]

First time using the Detour Tool. Fun challenge, but makes me wonder wish that Alteryx had an equivalent formula to Excel's Networkdays function. 

Spoiler

Workflow:

Macro:

[NicoleJohnson]

My solution!

  

Spoiler

Created a macro that allows user to pick start & end date, and then choose whether to exclude holidays or not (using holiday file that I embedded into the macro). 



Working Days Calculator macro:

Cheers!

NJ

[jessle]

Spoiler

[johnzrgu75]

[Jean-Balteryx]

Here is my solution !