Forum Discussion
Solved
DATEDIFF Working Days MTTR
I have two date columns in created.date and update.date.. I need time difference between these two columns excluding fridays..please help
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
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
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