# Find total working days in a month

**URL:** <https://community.eazybi.com/t/find-total-working-days-in-a-month/1239>\
**Category:** Questions & Answers\
**Tags:** jira, calculatedmembers, mdx\
**Created:** [November 1, 2018, 2:14pm UTC](https://community.eazybi.com/t/find-total-working-days-in-a-month/1239 "2018-11-01T14:14:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Taral\_Almoula](https://community.eazybi.com/letter_avatar_proxy/v4/letter/t/e19adc/32.png) [@Taral\_Almoula](https://community.eazybi.com/u/Taral_Almoula)\
**Post date:** [November 1, 2018, 2:14pm UTC](https://community.eazybi.com/t/find-total-working-days-in-a-month/1239/1 "2018-11-01T14:14:42Z")

</div>

Hello,

I am trying to get the total number of working days in a particular month. I am trying to use DateDiffWorkDays but I have to enter dates manually for that. I wish to have it for every month in the year and next year, so adding dates manually to that function is not optimal. Is there any other way to do that? Any help will be appreciated.

Thank you.

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [November 8, 2018, 8:07am UTC](https://community.eazybi.com/t/find-total-working-days-in-a-month/1239/2 "2018-11-08T08:07:51Z")

</div>

Hi,

Your approach using function [DateDiffDays()](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/datediffworkdays) to count working days is correct.  
To make this function more flexible and count working days for any **Time** member (year, quarter, month, week) selected in the report you may use functions [StartDate](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/startdate) and [NextStartDate](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/nextstartdate) like this:

```
DateDiffWorkDays(
  [Time].CurrentHierarchyMember.StartDate,
  [Time].CurrentHierarchyMember.NextStartDate
)

```

This calculation takes into account [holidays listed in eazyBI import options](https://docs.eazybi.com/eazybijira/data-import/jira-issues-import#JiraIssuesImport-Timedimension) as well.

 ![Workingdays%20in%20period](https://community.eazybi.com/uploads/default/original/1X/d9c6a9052bc3cc4a53caefb1b62847b434d2d6e5.jpeg)

Best,  
Zane / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![Taral\_Almoula](https://community.eazybi.com/letter_avatar_proxy/v4/letter/t/e19adc/32.png) [@Taral\_Almoula](https://community.eazybi.com/u/Taral_Almoula)\
**Post date:** [December 3, 2018, 5:51am UTC](https://community.eazybi.com/t/find-total-working-days-in-a-month/1239/3 "2018-12-03T05:51:14Z")

</div>

Thank you very much. I was able to do it in a similar way.

---

<div class="post-metadata">

**Author:** ![Lucas\_Silva\_Dantas\_A](https://community.eazybi.com/user_avatar/community.eazybi.com/lucas_silva_dantas_a/32/7404_2.png) [@Lucas\_Silva\_Dantas\_A](https://community.eazybi.com/u/Lucas_Silva_Dantas_A)\
**Post date:** [July 18, 2022, 12:25pm UTC](https://community.eazybi.com/t/find-total-working-days-in-a-month/1239/4 "2022-07-18T12:25:24Z")

</div>

is there any way to sum all this ?