Forum Discussion
DATEDIFF Working Days MTTR
Hi Sandeep641,
Please refer to the following threads, and feel free to ask if you have any other issue.
calculate number of working days between 2 dates
DATEDIFF Working Days
Best Regards,
Angelia
Solution SageHi Sandeep641,
Could you please give sample data with expected results and I will make a try.
Thx
Ninter
CALCULATE(SUM(Dates[IsWorkDay]),DATESBETWEEN(Dates[Date],
'table1'[date1],'table1'[Date2])))
This is the formula I use... between dates that look like below image.. I want to exclude weekends..... but the result that I get is not correct .... when the actual difference is only one day ... I get it as 4 days ... it differs a lot.. can some one please help
v-huizhn-msftMicrosoft Employee
Hi Sandeep641,
Please refer to the following threads, and feel free to ask if you have any other issue.
calculate number of working days between 2 dates
DATEDIFF Working Days
Best Regards,
Angelia- v-huizhn-msft
Hi Sandeep641,
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.
Best Regards,
Angelia