Challenge #252: Working Days Remaining

[AYXAcademy]

A solution to last week's challenge can be found here. 

This week's challenge was submitted by @NapasornCh  - Thanks for your submission!

Everyone has deadlines in business so it's natural to wonder how many working days you have left before time is up!

This week's challenge is to create a macro to calculate the number of business days between two user-selected dates, excluding both weekends and any dates specified by an optional input file. The included input file contains US holidays for 2021, as well as a few vacation days. Your macro should also allow the end-user to select the starting and ending date for the period.

[Aaron_Harter]

I'm already counting the days until the next holiday!

Spoiler

Macro configuration:

[DaisukeTsuchiya]

Spoiler

I created Analytic App with Macro. I think starting date is between Jan 23 to 25 not Jan 19 in sample output.

[DeanWest]

Looking forward to the next holiday!

Spoiler

Spoiler

[patrick_digan]

Spoiler

[clmc9601]

@AYXAcademy, the output looks like it was configured to 1/25/21, not 1/19/21 as mentioned in the workflow instructions 🙂

Spoiler

[ggruccio]

Fun with macros!  I often equate interfaces with apps, but this works too!  

Spoiler

Created start date and end date user inputs, used to generate rows.  Then used a formula to get to day of week....filtered out Saturday and Sunday.  Then created detour logic with check box interface for whether or not to include the optional file.

[phottovy]

Good way to start the week!

Spoiler

[Kenda]

Spoiler

[RolandSchubert]

Spoiler