Is there a way to created a calculated column to show the day # in a month excluding weekends/holidays in a Date table.
So for example, I have 30 days in June 2018 and the day #'s of the month range from 1,2,3,...30. I want a calculation to exclude weeknds/holidays but still count the day so the month. In the case of June 2018, it would be a total of 21 days excluding weekends and holidays so I want want each day to range from 1-21 if they are not a weekend or holiday.
Was anyone able to look into for figure out a way to get this calculated column for working day number for each date in a date table? The reason I want this is for graphical purposes to have the working day show up instead of the day of the month.