This content has been marked as final. Show 3 replies
I have a set of data with number of cases a physician performs over months. I want to display that data over the average number of business days in a month. Here is a screen shot of what I am trying to do:
I'm not sure how to calculate the business days which will have to be fluid if in the middle of a month without a networkdays type excel formula. Note the bottom example if it was 4/13/18 and only 9 full business days had happened.