C:\Temp\Engine_16524_f7f964775c6944649fd967184fed163e_\Engine_16064_165b79abd0a442b19785b830a51fbdd8_.yxdb
Single
Profile
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:\Temp\Engine_16524_f7f964775c6944649fd967184fed163e_\Engine_16064_e319d0a23705412d8fa271fea276910f_.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:\Temp\Engine_16524_f7f964775c6944649fd967184fed163e_\Engine_16064_cdc2083a070d4947bfcedbf37fffaa27_.yxdb
Single
Profile
2021-01-01
2021-02-02
1.0 Dates table
C:\Temp\Engine_16524_f7f964775c6944649fd967184fed163e_\Engine_16064_8f8abd31d6d944e1a83ea5ad388f19a4_.yxdb
Single
Profile
1.10 Browse work days calendar
Start Date
Calendar
Date
10
[Start Date]
[Calendar] < [End Date]
DateTimeAdd([Calendar],+1,"days")
1.1 Create calendar
Date
Month dd, yyyy
1.3 Convert dates
Convert Date From:
Month dd, yyyy
1.2 Create text dates col & Day of week
Calendar txt = ToString([Calendar], 0)
Day of week = DateTimeFormat([Calendar],'...
1.4 Add text date col
Calendar txt
Alt Date txt
Date
FindWhole
Append
1.5 Flag holidays
Custom
!=
Day of week
True
fixed
2021-02-02 16:35:34
0
"Saturday"
2021-02-02 16:35:34
2021-02-02 16:35:34
1.6 Filter unwanted dates
1.7 Count work days
C:\Temp\Engine_16524_f7f964775c6944649fd967184fed163e_\Engine_16064_9d26c8be6a424d8db327ff712af26a31_.yxdb
Single
Profile
1.9 Browse dates count
1.8 Display work days calendar
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.”
Horizontal
Question
Date (49)
Question
Date (50)
challenge_252_HJM
NoCondition
(Always Run)
Dynamic
{{INPUT}}
51/Data/r[1]/c[1]
Update Cell
Expression
row 1
column 1
Dynamic
{{INPUT}}
51/Data/r[1]/c[2]
Update Cell
Expression
row 1
column 2
Tab
Questions
Tab (48)
Date
Choose start date
Date (49)
Date
Choose end date
Date (50)
Wizard