3 Replies Latest reply: Sep 14, 2016 2:57 PM by Stefan Wühl RSS

    Append Number to Day of Week

    Todd Johnston

      Hello All,

       

      My business is very cyclical within each month.  I would like to monitor performance based on the day of the week.  I was able to extract the day of the week using the weekday function.  My next step is to append/prepend a figure 1,2,3,4,5 to represent the weekday of the month.  First Monday = Monday1, Second Monday = Monday2, etc.

       

      Any idea as how to accomplish this?

       

      Thanks,

       

      TJ