Forum Discussion

JenWilson's avatar
JenWilson
Helper II
3 years ago

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