3 Replies Latest reply on May 7, 2018 3:22 PM by Deepak Rai

    Average month totals by number of monthly business days?

    Andrew Shen

      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.  

       

      Thanks,

      Drew