Forum Discussion
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
4 Replies
Hi 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
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
