C:\Users\216005535\AppData\Local\Temp\Engine_7072_513009c8e4aa4a3cad315dfa38433500_\Engine_10300_02ee70c57b1a40b2b02ffa16b1c6f732_.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:\Users\216005535\AppData\Local\Temp\Engine_7072_513009c8e4aa4a3cad315dfa38433500_\Engine_10300_c057c06eef8e4432b48a4cbc4f269dc4_.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\216005535\AppData\Local\Temp\Engine_7072_513009c8e4aa4a3cad315dfa38433500_\Engine_10300_276e62822b3144a6b40653f353f6575b_.yxdb
Single
Profile
C:\Users\216005535\AppData\Local\Temp\Engine_7072_513009c8e4aa4a3cad315dfa38433500_\Engine_10300_0b4b7b2066274e9eaca8dcb70b89c434_.yxdb
Single
Profile
2021-01-25
2021-12-31
252 (48)
C:\Users\216005535\AppData\Local\Temp\Engine_7072_513009c8e4aa4a3cad315dfa38433500_\Engine_10300_af3aeaa4d345452d990839845417435f_.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.”
Horizontal
challenge_252_start_file