Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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