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

alacoume
8 - Asteroid

Here is my macro:

Spoiler
Challenge_252.jpg
networkmike42
8 - Asteroid
Spoiler
Screenshot 2023-10-30 170848.png

shrestha_nitesh
8 - Asteroid
Spoiler
Challenge 252 Screenshot.png

SylwiaDragon
8 - Asteroid

Done

olga_strubbe
10 - Fireball

This was a fun challenge, thank you, @NapasornCh!

My solution attached. 

 

My analytic app:

app.png

 

My macro: 

 

macro.png

asultanov
8 - Asteroid

Made to work with multiple years of holidays.

Spoiler
Screenshot 2024-02-14 135811.pngScreenshot 2024-02-14 135825.png
danbostrom
8 - Asteroid

 

 

Rob-Silk
8 - Asteroid

Solution attached below:

 

Spoiler
challenge_252a_RS_screencap.PNGchallenge_252b_RS_screencap.PNG
lars3033
6 - Meteoroid

Shouldn't we be getting 234 from 2021-01-25 through 2021-12-31 ?

 

I read the question as including the starting date.  If using DateTimeDiff(), it will count one less day than the range because it's taking a difference.

 

For example, there are 31 days every January, but DateTimeDiff() will only give you 30 ...