How do I create a workday formula to track # of days an event takes place?

Options
Elisa Tiffee
Elisa Tiffee ✭✭
edited 05/28/20 in Formulas and Functions

We want the date range to display in the calendar view.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcIAAABJCAYAAACuGCbqAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAA8HSURBVHhe7Z1PyBXVG8fP+/sFYYugosQ/kKhBUEEQuZBUaqHuCnKhLUICA20TFrnIhQtdKBYkqGBQQpAuXBRCqAshjZewAsFapWHxKlSkC6OMAruf4zy35z3vmXvneufe977vfD8wzpkzc2bOzPM9z3POmbmvYxMTE7eCEDVw/fr1cN999xVbQtSDdCUGgdfV/+K/QgghRENRIBRCCNFoFAiFEEI0GgVCIYQQjUaBUAghRKNRIBRCCNFoFAiFEEI0GgVCIYQQjUaBUAghRKNRIBQzkq+++ips3Lix2BKiPr799tuwdevWqC90Nkpcu3Yt7Nq1K9bt6NGjRa7ol9I/sYYYPv300/D999/H7ccffzysW7cuLFq0KG5jiNdeey08/fTTcbsXENf+/fvD4cOHi5zJeAc3Z86c8MQTT4T169eH+++/v8gtp9u5xeCo8qewyoJXr/bqZOd+9AP9aFvUTy9/Yu3DDz8MS5YsCStXrgybN28OBw8eLPZUZ+/evXH95ptvxrWHIGQ+EfCLa9eujeth8Mknn4QzZ86E7du3V9bzqDBq7arrn1ij14GTQVA4mnfffTfcc889Yd++fcURg4cHxrURHrzzzjuxXmLmY7b1S91IP83k4sWLMSjRUcJ/3Ql//fVXWLhwYbE1FQKf6Xbp0qXRVzJwGAY3b94MDzzwwIwLgqPO/7du3bqjSLfBqOPj42HLli2xR81CFP/666/Dr7/+Gvbs2ROPQ2wYBuFR5r333gsfffRR7LFQ5uGHH47H0RMg+rL/8uXL4fjx4zGf3s2CBQvi4iF/2bJlMd+uffr06fDPP/+ERx99NB5Dz+/QoUPh2LFj4erVq1H0jGCPHDkS9/tzUx+uzb7vvvsuiuihhx6Kx4n6QAvYqxPetilM9aCpzz77LHzwwQfRbhxntsLm2PHkyZNRC1euXAkvvPBC3Oepop8TJ06EAwcOTNLEjz/+GN5+++24P9X2+++/366T17YYPFV0RYcH+9y4cSPqA/v98ssv0baMDj10iNASAQytmP/gGvgq9hNQc2XPnj0btWIjQPSET7xw4UJYvnx5zCvzheiNetmIyDS4Zs2aSXrkmLlz507xUdzjuXPnYv2ot2mfdsO94AtT/+Z9r/lDjy9rz+Hnn38Or7/+erx3e+60i7///jsG/jJ/Sr3pHFy6dKndTu+66654/Vy7mm68rrIjQgzFA6MXzU0b3MyLL77Y7sHT62bKCcPwMFesWBH38QAtIBl//vlnPP7ll1+Oa+BYE0U3mN7ioQPGQ6gIg9EqaepJXdJzE3hpIBs2bIh58+fPjwFTjCY09Oeff75tKxwEmM137NjRHuX1gtcPjRENvPLKK/E6d999d7wOemEbTNuAfmx2BOeDtjW6HC3wTdgMB4udWLNtDtiDlv7444/oO1joUJlPoOwjjzwSR325sjmsswSdfCHHETANyqBLylAn0yN5aC6F+lAv6sdxgG5pM9u2bYt5TPWV+d50hOzL8hwIWKdOnYqvv/D/7AN8KM+IzmU3f8q08bx58+I+Ajz7ytrVKFH6scwbb7wRDULPg14FvRUeQhkYESMBzoKHb+IARpc8EHoP/YKgNm3aFM/FgoFwkjm+/PLLuN8CLk4WY8mRTR84CjRlC4HJWLVqVbQvMD3FNBXgQHAuNFJsbva8Ex588MG20wSuSS82h9XNGi+Ojet7bYvRAGfNiAVsdJMDB4+vMv+BU//888+Lvf1T5gvRDph2WHsd48PwsatXr451qsI333wTz2vfbuBn8W2+TZX5XspyLWtTtC8L1KStnufPn49thWO6+VPrRADBlHufCZQGQm6axk9PgZfG9KB2795d7J0Mx/7222/tL61YYFAPgV4IQ3m7Fj0bc5gpODiEb8dSR8sX0wNBiB6iLVWCGk6OdyN1QMPHUfAxBZogMJdpFZ3QyE0/LNQFRytGA2yJXei0W8cdm9HWfUAA27ZOEPh0v3TzhQwuqAMzWBxrAYY2QSDExzITV9V3EoTS6c5O7zc9lGUkavVkpIe2gWBHIOQ5MpPCNsxWf5oNhAQWRoAGxiIYYpxUWMADYwhsw2UbBtcJPZXHHnsspjEYH+8QpLmW9UByEDTp8Vu9bOlnRCGGD40dB3OneP3gLHE6Np2EEyoD/XDtVD+jOL3TVGjL2AQ74RNstE9e2s5t289u5XxaL+D/LJh284UchxY5jqAI1IV3VfhYvnKljun0ZhmMwNJ2QYCrAs/LpmP9AhakCdgTExPt0exs9afZQMgLYIyFwzBIYyybbiBtvRZbM+UEvlwOe0Fpw+lOIBILymYMRn+cA2Ox34bzkJ4bY9KDMbGz9kFezAxwGnyogL2xbVXnldMPL8npSN17773Zc3ltox+OMU3b+ViL0QI74RMY1XQaFTG6YUaJ4822NuLpBStrU63QzReaBvFZzz77bEz//vvvcVbCdMg9VOWpp56K7/VMj2iT8lUCE22KD1qsLAMgRogG2me/BWzox5/6djVqZAMhU0c2VLchMDdM78GMRK+AkRkPjoeOkPiQgekmXrp2godJTyY3dWHYeySbjuWdpV2beWmExH6+5vO/MUrPTd3ondHD4njWHCOmj/QdIUs3GIHx/geNVfmIoZN+eC8CaGTnzp0x7fHapgxtgekhOx959k5GjAaMsCz44X8YuZSBlugIYX8WRka9jPAJGGiBsvhIG4FCFV9IYPEaoiw+zXwUwbPqO0ICMNdDl5TlevjpKnDP1MXK8s7Q+0YL7j6vH3/q29WoUfqDeiF6hUZY9YfPQlRltumKn25wP7mf/ojh4XVV+rGMEEKIemEakqnFJ598ssgRo4ACoRBCDAGmBJkyZRpUU+ujhaZGRW1oalQMAulKDAJNjQohhBAFCoRCCCEajQKhEEKIRqNAKIQQotEoEAohhGg0CoRCCCEajQKhEEKIRqNAKIQQotEoEAohhGg0CoRCCCEajQKhEEKIRjN24cIF/a1RIYQQjWXsxo0bCoSiFvgvZvRX9UXdSFdiEHhdaWpUCCFEo1EgFEII0WgUCIUQQjQaBUIhhBCNRoFQCCFEo1EgFEII0WgUCIUQQjQaBUIhhBCNRoFQCCFEo1EgFEII0WgUCIUQQjQaBUIhhBCNRoFQCCFEo1EgFEII0WjGxsfH9d8wCSGEaCxjt1oUaSH64sqVK2HBggXFlhD1IF2JQeB1palRIYQQjUaBUAghRKNRIBRCCNFoFAiFEEI0mtJAODY21l7KWLt2bTh69Gix9R9btmxp5+/Zs6d9HtI5vvjii7B06dJi6z9++OGHdr4/DwtlPFWuI6Yfb8My+tUVx3S6jnQ1+8A2Zp9UJ963kEZfKeRZ+bJjTFepRsqOT6+dwrmsnqlmbbH9ZeTK5Opi5OrK/eTOYwvtxVN2vx7uPXcuFsrb/vTc4M/POi2fluP43DHkV4avRlM2b94clzTtWbNmDV+b3jpy5EiR8x9Lliy5denSpbhwTJr2nD17NuZTJoVzc23Wfj/b/lxVriMGz8TERJHKMwxdmZ4MrsE5PdLVzKKbrgAbY/s0vXv37kk2Jo0dU31RhmOBtdeQgWb8uYDrmGZTbaTXTvH1MO15THNpXT25/dSHJaVTXQ1rP532dztHStlzyNUzPZb9qZ9IjyFNXq94XWVHhAcPHgwvvfRSTLNm27DeQxkWqRcvXhyOHTsWWjcS0yykyTOI9itWrIj5Oc6cORNWrlwZ1q9fHy5evFjkhrgN586di+tu1xGjwTB09cwzz+BNYhrQz8mTJ4ut20hXsw/siO0Be1s6B3bcsGFDsTWV5cuXx3U68kOvr776arF1m48//jg899xzoeWsa9cGmmsFubB9+/YipxonTpyIzyCtfx11rfN+Dxw4EOvpR73btm0Lhw8fLrbyrFu3LrSC8JT764cpgdAczvz58yet/VC01SuIDzsHTmT16tUxffny5WhMgzR5Bg8Up8U6x6lTp8KyZcuKraksXLgwrrtdR0w/w9SVh6CH4/NIV7MHmwbDMVra8r22PBs3boyaYAo1B0G0NcqITt8wp4sT9hAcyaNjd+jQoSK3PtDpnTh97s/XH+qoa533S3tqjeTanRLsQYDt1InxmA+pgymB8OrVq0VqMpZPJTtV1HrbkBOiz3vrrbeK1FTsOO+IDJvLt3p0u46YfoapK8Bx4AxpuPQ8DelqdkFHmlETDjRN52xsoAm0URZgGPnRYTIIKgQXf05GMpZnmqlzlAKd7qETabk66jqI+yUG0OngfV7aVsvYu3dvLOPvkZGkdYRssfZchdq/Gu3W266KHwF4ePDcNKMH0Rx61RUNFWeITmg01mClq9nHTz/9FBYtWhTTvsPUCZwoAXPnzp1FzmSYHmUkZh0f9JfOXDGFx+jSIHiWnW+6qaOug7pfzsuzphOTgwDpAxzbvpMCjCxp737pNNBKmRIIy4abVYahiIbIbpHaR2wjl5cDQdv7JANnxTtFnJX1SKCf64jhMF26QicEwvHx8bgtXc0ucIx0YGxEgJNkqo10t9F77h2VYbrhPRj6wFH7aVHOTVm7ltWDvG7X7QU7V6/TgJSzzkEdda3jHGXYvdkriRQb4ful7nY4JRDaBWzKytZVLoxofK8JQ/iHRNqM0w0E7Z1SmbOCfq4jhoN0JQYBTtHWabqKthiF2DuqFEY8p0+fzk6Losmcg7bgWRecK50G7AY6JUDZRz911HVY9ztdZKdGMbq9aGXNA6gCorGHD6Stx2DGSV8258A5UQeDsmXOCu70OmK4DENX9O7prRq8J7DevHQ1+8AuOGNI7VsFvhSmDLZNMfvTefJTgsCHIrkpWIJnXR/NcG+MunqdfuSjE+7JNF1HXYdxv9NKK6pnYZctZbCv1aMqtm5vp/D7DjtP2W89yG+Judi6ve2PbTnM9jn84o8hncsXw6PK7728/cpgXz+68vtYWoGwne+Pla5mBp10hU6wY5o2sJn3LaS9tgB9lNmX49nnoXyaZ9i5Wp2rSdrxi13fp+2c6ZLWNSVXphUEi73V62qQJs/aDPR6jpTUBimdzsG9pDZNMRvlFn8fKV5X+m+YRG3ov8sRg0C6EoNA/w2TEEIIUaBAKIQQotEoEAohhGg0CoRCCCEajQKhEEKIBhPCv1wkuFJJnH1vAAAAAElFTkSuQmCC There was an error displaying this embed.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!