Forum Discussion
Calculate date difference excluding weekends
Hi,
I am trying to see the difference in days between when we are expecting to receive a shipment and the date the shipment actually arrives. The calculated column below is showing values correctly for shipments that are received on time (results 0 if dates are a match) or late (example: Expected Date is 04/26/2023 and Received Date is 05/01/2023 result is 3). However, for shipments that are received earlier then the Expected Date, the result is always showing -1. Is there something wrong with the formula below?
Date Difference = CALCULATE(COUNTROWS('Calendar'),FILTER('Calendar',WEEKDAY('Calendar'[Date],2)<6),DATESBETWEEN('Calendar'[Date],'DataTable'[Expected Date],'DataTable'[Received Date]))-1
1 Reply
- IdrissshatilaSuper User
Hello JenWilson ,
check this video, it helped me with a similar case.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍