Challenge #248: Holidates
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Alteryx
12-28-2020
05:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Basic
- Core
- Data Analysis
- Join
- Preparation
16 - Nebula
12-28-2020
06:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Aaron_Harter
11 - Bolide
12-28-2020
06:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy Holidays!
Blake
12 - Quasar
12-28-2020
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
16 - Nebula
12-28-2020
06:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sara_burk
7 - Meteor
12-28-2020
08:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JasonFruh
5 - Atom
12-28-2020
09:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
12-28-2020
10:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
balajilolla
8 - Asteroid
12-28-2020
11:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Solution Attached

Spalders
8 - Asteroid
12-28-2020
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator