Challenge #252: Working Days Remaining

[alacoume]

Here is my macro:

 

Spoiler

[networkmike42]

Spoiler

 

[shrestha_nitesh]

Spoiler

 

[SylwiaDragon]

Done

[olga_strubbe]

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

My solution attached. 

My analytic app:

My macro: 

[asultanov]

Made to work with multiple years of holidays.

Spoiler

[Rob-Silk]

Solution attached below:

Spoiler

[lars3033]

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

[BS_THE_ANALYST]

Nice stuff.

Spoiler

All the best,

BS