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

    Count the number of workdays in a month


      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.