2021-01-01
New Year's Day
AUS
2021-01-26
Australia Day
AUS
2021-03-08
Labour Day Victoria
AUS
2021-04-02
Good Friday
AUS
2021-04-05
Easter Monday
AUS
2021-04-26
for Anzac Day
AUS
2021-06-14
Queen's Birthday
AUS
2021-11-02
Melbourne Cup
AUS
2021-12-25
Christmas Day
AUS
2021-12-28
Boxing Day
AUS
2021-12-27
for Christmas Day
AUS
AUS Holidays
AUS Holidays
2021-01-01
2021-12-31
Calendar Year
Start & End Dates
Calendar Year
Start & End Dates
2021-01-01
New Year's Day
US
2021-01-18
Martin Luther King, Jr.
US
2021-02-15
Presidents' Day
US
2021-05-31
Memorial Day
US
2021-07-05
Independence Day
US
2021-09-06
Labor Day
US
2021-10-11
Columbus Day
US
2021-11-11
Veterans' Day
US
2021-11-25
Thanksgiving Day
US
2021-12-24
Christmas Holiday
US
2021-12-31
New Year's Holiday
US
US Holidays
US Holidays
Business Day
Date
10
[Begin_Date]
[Business Day] <= [End_Date]
DateTimeAdd([Business Day], 1, 'days')
[Day] NOT IN ('Saturday', 'Sunday')
Custom
[Day] NOT IN ('Saturday', 'Sunday')
Elf 1
US
Elf 2
US
Elf 3
AUS
Warning
All
ByName
Warning
All
ByName
,
D:\Alteryx\Challenge\2020\248\Output.xlsx|||Sheet1
False
False
Overwrite
Output.xlsx
Query=Sheet1
generate dates in range
Days of week
keep business days only
list of employees and region
assign regional holidays to employees
list of employees / holidays
join holidays per employee and business days
complete list of business days and holidays
cross-tab, employees to columns
remove fields
Simple
IsNotEmpty
Holiday
True
fixed
2020-12-28 15:47:57
0
2020-12-28 15:47:57
2020-12-28 15:47:57
!IsEmpty([Holiday])
Error
split holidays
number of holidays by region
number of business days including holidays
calculate number of Business Days
C:\Users\ROLAND~1\AppData\Local\Temp\Engine_9644_9f90e8e0a5c747cb9165b1a62f6306dd_\Engine_14064_b71f8a7cd5a543c08c8a773a8bb90fc0_.yxdb
Single
Profile
Horizontal
challenge_248_solution_rsc