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... 

 

Spoiler

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
7 - Meteor

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

 

Spoiler
VictorLeonis_0-1629387151654.png

 

Erin
10 - Fireball

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

 

Spoiler
BronzeFox_1-1629908645126.png

 


BronzeFox_0-1629908634204.png

 

surajmthomas
8 - Asteroid

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

 

Spoiler
Capture.PNG

Sebastiaandb
12 - Quasar

Here is my solution!

 

Spoiler
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

 

Spoiler
estherb47_0-1638808251417.png

 

Abhishekanand97
7 - Meteor

Here's mine. Business_Days.png

fvojtesek
8 - Asteroid

My Solution.