I am trying to develop a workflow to count holidays. Have the idea to format date , "MMdd" excluding the year. I want it to loop using create date incrementing by 1 until it equals SentDate. I was thinking of using a switch or run if as I need 1224 (christmas eve to add .5) and 1225 (christmas Day to add 1).
What I envisioned is it looping until create date = sent date and each time the incrementd date would get formatted to MMdd and checked and either add .5 for half day or 1 for full day off. Excluding the year would allow it to run indefinatly.
The set Holiday = to sum of all between create date and sent date.
Any help is greatly appreciated. This is my first loop.
Solved! Go to Solution.
I created a workflow (attached) based on your idea where I have a switch with the holidays and if that holiday comes up it goes down the branch and adds a day to the holiday count variable.
Holidays I used are based on:
Any questions let me know,