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

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
9 - Comet

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