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

LHolmes
9 - Comet

Nice way to start the week... especially as project dates seem to be fluid 🙂

 

Spoiler
Configured Macro to work even if the start date is after the end date. Also included a mapping for the holidates so the incoming data fields don't have to be altered.

SolutionSolution

InterfaceInterfaceMacroMacro
RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

 

Workflow:

 

Spoiler
challenge252.jpg

Macro:

 

Spoiler
macro252.jpg

 

Tony_Castillo
9 - Comet

Good Challenge! Same note as others , the BD count shown is for Jan 25 starting date.

 

Spoiler
Macro:
TC_bot_0-1611602682270.png



Workflow:

TC_bot_1-1611602701550.png

 

Good  

toconne3
5 - Atom

Learned a lot while trying out my first weekly challenge macro!

Spoiler
Weekly Challenge 252.pngWeekly Challenge 252.png

 

dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1611611027830.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1611612945686.png

 

Qiu
20 - Arcturus
20 - Arcturus

Get to know a bit more about the Interface tool

en-252.PNG

kelvin_law1
8 - Asteroid

Here is my solution with the macro:

Spoiler
kelvinlaw_0-1611624134350.png

 

kelvinlaw_1-1611624161782.png

 

 

Sashikumar
8 - Asteroid

Good one.ch252.PNG

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1611640466862.png


Macro:

AkimasaKajitani_1-1611640489649.png