C:\Users\tdc2\AppData\Local\Temp\Engine_25636_70c6c1f7bd0a4f0eaba96962cb9e367d_\Engine_12664_6709472964f14750b00b113d5f46811e_.yxdb
Single
Report
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #252
Create a macro to calculate the number of business days between two user-selected dates, excluding both weekends and dates specified by an optional input file. Note: output files configured for starting date of Jan 19, 2021 and ending date of Dec 31, 2021.
C:\Users\tdc2\AppData\Local\Temp\Engine_25636_70c6c1f7bd0a4f0eaba96962cb9e367d_\Engine_12664_b7f9a3b2ec324254b5225e95d00a6a11_.yxdb
Single
Profile
New Year's Day
Jan 1, 2021
Martin Luther King Jr. Day
Jan 18, 2021
Mental Health Awareness Day
May 7, 2021
Memorial Day
May 31, 2021
Independence Day
Jul 5, 2021
Labor Day
Sep 6, 2021
World Mental Health Day
Oct 13,2021
Veterans Day
Nov 11, 2021
Thanksgiving
Nov 25, 2021
Christmas Day
Dec 24, 2021
New Year's Day
Dec 31, 2021
Rick's Day Off
Apr 1, 2021
Rick's Day Off
Apr 13, 2021
Rick's Day Off
May 5, 2021
2021-01-25
Mon
2021-01-26
Tue
2021-01-27
Wed
2021-01-28
Thu
2021-01-29
Fri
2021-02-01
Mon
2021-02-02
Tue
2021-02-03
Wed
2021-02-04
Thu
2021-02-05
Fri
2021-02-08
Mon
2021-02-09
Tue
2021-02-10
Wed
2021-02-11
Thu
2021-02-12
Fri
2021-02-15
Mon
2021-02-16
Tue
2021-02-17
Wed
2021-02-18
Thu
2021-02-19
Fri
2021-02-22
Mon
2021-02-23
Tue
2021-02-24
Wed
2021-02-25
Thu
2021-02-26
Fri
2021-03-01
Mon
2021-03-02
Tue
2021-03-03
Wed
2021-03-04
Thu
2021-03-05
Fri
2021-03-08
Mon
2021-03-09
Tue
2021-03-10
Wed
2021-03-11
Thu
2021-03-12
Fri
2021-03-15
Mon
2021-03-16
Tue
2021-03-17
Wed
2021-03-18
Thu
2021-03-19
Fri
2021-03-22
Mon
2021-03-23
Tue
2021-03-24
Wed
2021-03-25
Thu
2021-03-26
Fri
2021-03-29
Mon
2021-03-30
Tue
2021-03-31
Wed
2021-04-02
Fri
2021-04-05
Mon
2021-04-06
Tue
2021-04-07
Wed
2021-04-08
Thu
2021-04-09
Fri
2021-04-12
Mon
2021-04-14
Wed
2021-04-15
Thu
2021-04-16
Fri
2021-04-19
Mon
2021-04-20
Tue
2021-04-21
Wed
2021-04-22
Thu
2021-04-23
Fri
2021-04-26
Mon
2021-04-27
Tue
2021-04-28
Wed
2021-04-29
Thu
2021-04-30
Fri
2021-05-03
Mon
2021-05-04
Tue
2021-05-06
Thu
2021-05-10
Mon
2021-05-11
Tue
2021-05-12
Wed
2021-05-13
Thu
2021-05-14
Fri
2021-05-17
Mon
2021-05-18
Tue
2021-05-19
Wed
2021-05-20
Thu
2021-05-21
Fri
2021-05-24
Mon
2021-05-25
Tue
2021-05-26
Wed
2021-05-27
Thu
2021-05-28
Fri
2021-06-01
Tue
2021-06-02
Wed
2021-06-03
Thu
2021-06-04
Fri
2021-06-07
Mon
2021-06-08
Tue
2021-06-09
Wed
2021-06-10
Thu
2021-06-11
Fri
2021-06-14
Mon
2021-06-15
Tue
2021-06-16
Wed
2021-06-17
Thu
2021-06-18
Fri
2021-06-21
Mon
2021-06-22
Tue
2021-06-23
Wed
2021-06-24
Thu
2021-06-25
Fri
2021-06-28
Mon
2021-06-29
Tue
2021-06-30
Wed
2021-07-01
Thu
2021-07-02
Fri
2021-07-06
Tue
2021-07-07
Wed
2021-07-08
Thu
2021-07-09
Fri
2021-07-12
Mon
2021-07-13
Tue
2021-07-14
Wed
2021-07-15
Thu
2021-07-16
Fri
2021-07-19
Mon
2021-07-20
Tue
2021-07-21
Wed
2021-07-22
Thu
2021-07-23
Fri
2021-07-26
Mon
2021-07-27
Tue
2021-07-28
Wed
2021-07-29
Thu
2021-07-30
Fri
2021-08-02
Mon
2021-08-03
Tue
2021-08-04
Wed
2021-08-05
Thu
2021-08-06
Fri
2021-08-09
Mon
2021-08-10
Tue
2021-08-11
Wed
2021-08-12
Thu
2021-08-13
Fri
2021-08-16
Mon
2021-08-17
Tue
2021-08-18
Wed
2021-08-19
Thu
2021-08-20
Fri
2021-08-23
Mon
2021-08-24
Tue
2021-08-25
Wed
2021-08-26
Thu
2021-08-27
Fri
2021-08-30
Mon
2021-08-31
Tue
2021-09-01
Wed
2021-09-02
Thu
2021-09-03
Fri
2021-09-07
Tue
2021-09-08
Wed
2021-09-09
Thu
2021-09-10
Fri
2021-09-13
Mon
2021-09-14
Tue
2021-09-15
Wed
2021-09-16
Thu
2021-09-17
Fri
2021-09-20
Mon
2021-09-21
Tue
2021-09-22
Wed
2021-09-23
Thu
2021-09-24
Fri
2021-09-27
Mon
2021-09-28
Tue
2021-09-29
Wed
2021-09-30
Thu
2021-10-01
Fri
2021-10-04
Mon
2021-10-05
Tue
2021-10-06
Wed
2021-10-07
Thu
2021-10-08
Fri
2021-10-11
Mon
2021-10-12
Tue
2021-10-14
Thu
2021-10-15
Fri
2021-10-18
Mon
2021-10-19
Tue
2021-10-20
Wed
2021-10-21
Thu
2021-10-22
Fri
2021-10-25
Mon
2021-10-26
Tue
2021-10-27
Wed
2021-10-28
Thu
2021-10-29
Fri
2021-11-01
Mon
2021-11-02
Tue
2021-11-03
Wed
2021-11-04
Thu
2021-11-05
Fri
2021-11-08
Mon
2021-11-09
Tue
2021-11-10
Wed
2021-11-12
Fri
2021-11-15
Mon
2021-11-16
Tue
2021-11-17
Wed
2021-11-18
Thu
2021-11-19
Fri
2021-11-22
Mon
2021-11-23
Tue
2021-11-24
Wed
2021-11-26
Fri
2021-11-29
Mon
2021-11-30
Tue
2021-12-01
Wed
2021-12-02
Thu
2021-12-03
Fri
2021-12-06
Mon
2021-12-07
Tue
2021-12-08
Wed
2021-12-09
Thu
2021-12-10
Fri
2021-12-13
Mon
2021-12-14
Tue
2021-12-15
Wed
2021-12-16
Thu
2021-12-17
Fri
2021-12-20
Mon
2021-12-21
Tue
2021-12-22
Wed
2021-12-23
Thu
2021-12-27
Mon
2021-12-28
Tue
2021-12-29
Wed
2021-12-30
Thu
233
C:\Users\tdc2\AppData\Local\Temp\Engine_25636_70c6c1f7bd0a4f0eaba96962cb9e367d_\Engine_12664_46ec7eae09c84aad8769bb75a874afe7_.yxdb
Single
Profile
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Business Day Macro
Data Prep
Business Day Calc Data Prep
Begin_Date = DateTimeFormat([Begin_Date],"%Y-%m-%d")
End_Date = DateTimeFormat([...
Calendar_Day
String
10
[Begin_Date]
[Calendar_Day] <= [End_Date]
DateTimeAdd([Calendar_Day],1,"days")
Generate dates between start and end dates.
[Day] NOT in('Sat','Sun')
Custom
[Day] NOT in('Sat','Sun')
Format dates to pull Day of the week
Filter out Weekend days
Filter US Region Holidays
Calendar_Day
Date
Region
FindAny
Append
US Holiday Insert
US Holiday Insert
Simple
IsNull
HolidDateTime_Out
True
fixed
2021-01-25 12:50:57
days
0
2021-01-25
2021-01-25 12:50:57
2021-01-25 12:50:57
IsNull([HolidDateTime_Out])
Region Holiday Data Cleanup
False
False
"Reason","Date"
True
True
True
False
False
False
False
False
False
upper
Date
English
%b %d,%Y
HolidDateTime_Out
Convert Date From:
Custom
Inputs
2021-01-25
2021-12-31
Calendar Year
Start & End Dates
Calendar Year
Start & End Dates
Input95
C:\Users\tdc2\Downloads\Challenge 252 Holiday Inputs.xlsx|||`Sheet1$`
False
1
Challenge 252 Holiday Inputs.xlsx
Query=`Sheet1$`
Outputs
Output94
Output
BD Counts
Output96
Output
Update Value
Date (88)
Date (90)
Update Value
Horizontal
Question
Date (88)
Question
Date (90)
Question
Macro Output (94)
Question
Macro Output (96)
Question
Macro Input (95)
challenge_252_Macro_BD_Calc
NoCondition
(Always Run)
UpdateValue
Simple
71/Data/r/c[1]
UpdateValue
Simple
71/Data/r/c[2]
Tab
Questions
Tab (87)
Date
Begin_Date
Date (88)
Date
End_Date
Date (90)
MacroInput
Macro Input (95)
Macro Input (95)
MacroOutput
Macro Output (94)
Macro Output (94)
MacroOutput
Macro Output (96)
Macro Output (96)
Macro