10 Replies Latest reply on May 24, 2016 12:42 PM by thejash.vn

    Count the number of workdays in a month

    thejash.vn

      Hi Everyone,

       

      I need your help!.

      I got some issues with Calculating the Number of Business Days in a month . Below I have attached the screenshot of my workbook and I am also attaching the excel sheet with the list of holidays. I am getting some error with the calculation I have used. For example in the attachment 1.png , for the month of April there are 21 working days. But its displaying as 22. All the calculations I have used can be seen in the screenshot.

       

      To give you a clear idea, Count of business days = Days in the calendar - weekends - Holidays.

       

      Hope someone helps me out with this issue.

       

      Thanks