Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

KaneG
Alteryx Alumni (Retired)

A problem for the ages, this one... 

 

スポイラ

Rather than possibly have a different format come in, just label the interface to say that it must be formatted as a Date

KaneG_0-1629349566188.pngKaneG_1-1629349619822.png

And the Macro:

KaneG_2-1629349656685.png

 

 

VictorLeonis
メテオール

In my point of view, We should have more holidays and weekends in the year. lol 

 

スポイラ
VictorLeonis_0-1629387151654.png

 

Erin
ボリード

First time using interactive tools in a macro vs an app! 

 

スポイラ
BronzeFox_1-1629908645126.png

 


BronzeFox_0-1629908634204.png

 

surajmthomas
アステロイド

surajmthomas_0-1629978944059.png

 

surajmthomas_1-1629978983256.png

 

 

MatthewBr
Alteryx Alumni (Retired)

I love testing my macro capabilities

Michael_McKee
Alteryx Alumni (Retired)

Here is the Macro

 

スポイラ
Capture.PNG

Sebastiaandb
クエーサー

Here is my solution!

 

スポイラ
Sebastiaandb_0-1636534254251.pngSebastiaandb_1-1636534271647.png

 

estherb47
15 - Aurora
15 - Aurora

Decided to pop in a few calcs to limit the years to 2021

 

Cheers!

Esther

 

スポイラ
estherb47_0-1638808251417.png

 

Abhishekanand97
メテオール

Here's mine. Business_Days.png

fvojtesek
アステロイド

My Solution.