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

chara123
アステロイド

Here is my solution Challenge 252.png

acarter881
クエーサー

Here's my solution (standard macro).

スポイラ
my_weekly_challenge_252_solution.png
alisonpitt
ボリード

Like others have said, I think the starting date goes from 1/23 or 1/25 instead of 1/19.

スポイラ
challenge-252-ap.pngchallenge-252-macro-ap.png
DenisZ
ボリード

My solution

 

スポイラ
DenisZ_0-1665988450577.png

 

スポイラ
DenisZ_1-1665988463526.png

 

mgaronson
ボリード
スポイラ
mgaronson_0-1666030617150.png
Macro
mgaronson_2-1666030703774.png

 

Super struggled with this - macros are a challenge for me. 

Gem
コメット

Learned a few new tools with this one :) 

martinding
パルサー

252 1.png

スポイラ
252.png

My favourite activity on 1st Jan every year is to mark every holiday in the year! 😉

RWvanLeeuwen
ボリード

Workflow

スポイラ
252 workflow.png

 

Macro

スポイラ
252 macro.png
karlhansen
コメット
スポイラ
solution_252.jpgsolution_252app.jpg

Um, I am showing the number of workdays in the user-chosen range that also fall within the specified range.  I probably only needed the number of days in the input range. 

ahsanaali
ボリード
スポイラ
ahsanaali_0-1667481697602.png