formula for the number of working days between two dates

[gregboothdelt]

Hi

Does anyone know a formula to calculate the number of working days between two dates ?

Thanks

[gregboothdelt]

The formula needs to exclude the weekends and other non working days

[v-yalanwu-msft]

Hi, @gregboothdelt ;

You could create a date table ,then create a measure to calculate a measure.

Table = CALENDAR(DATE(2021,4,9),TODAY())

then create a measure

Count = CALCULATE(COUNT([Date]),FILTER(ALL('Table'),[Date]<=TODAY()&&[Date]>=DATE(2021,9,1)&&WEEKDAY(MAX([Date]),2)in {1,2,3,4,5}))

here could change Today() to end date , DATE(2021,9,1) to start date.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Share some data and show the expected result.

[VijayP]

@gregboothdelt 
DATEDIFF(startdate,enddate,DAY)