Challenge #248: Holidates

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

This week's challenge was submitted by @Tony_Castillo - Thank you for your submission!

Looking to the new year (2021), we want to produce a log for our staff showing workdays for the upcoming year. 2 employees follow the US holiday schedule and 1 employee follows the Australian (Victoria) holiday schedule. Produce an Excel file showing the business days with holidays for all 3 employees.

Bonus: How many US and Australian business days are there in 2021?

challenge_248_start_file.yxzp

Output.xlsx

challenge_248_solution.yxzp

Join

Preparation

Data Analysis

Core

Basic

Accepted answers

All comments

Kenda

Spoiler

challenge_248_start_file.yxmd

Aaron_Harter

Happy Holidays!

Spoiler

challenge_248_AB Data_Aaron.yxzp

Blake

Happy Holidays!

Spoiler

250 US Business days and 251 AUS Business days for the bonus.

See below for a video walkthrough of this challenge.

Spoiler

challenge_248_BH.yxmd

RolandSchubert

Spoiler

challenge_248_solution_rsc.yxmd

sara_burk

Happy Holidays!

challenge_248_SB.yxmd

JasonFruh

Happy Holidays!

Spoiler

C248 JF.yxmd

atcodedog05

Fun and easy challenge

Spoiler

Cheers and Happy Analyzing 😀

challenge_248_atcodedog05_Solution.yxmd

balajilolla

Spoiler

Solution Attached

challenge_248_start_file.yxmd

Spalders

Spoiler

challenge_248_ADS.yxzp

TonyA

Had a little fun with this one. Made it general purpose so that with a tweak to the inputs it could accept any number of holiday files and an arbitrary number of Employee/Region pairs in an employee file. Did this with a macro first then realized there was an easier way.