Forum Discussion
Date Difference excluding weekends
Hello, I have a starting date and an ending date and I need to count only the working days in between. In other words, the date difference (DATEIFF) between the ending and the starting without tak...
Could you please resolve my issue.
I created a Date table:
Dim Table=CALENDAR(DATE(2008,1,1),DATE(2018,12,31))
I created a new column with is working day or not
is work day = SWITCH(WEEKDAY([Date]),1,0,7,0,1)
Now I want to create "DateDifference" Column with Createddate & Closeddate (I want to know day diffarence b/w these two dates excluding weekends)
CreatedDate ClosedDate DateDiffarence
Did you ever find an answer to this? I have been struggling for a few days trying to accomplish the same measure.
In my case:
Call Close - Call open then filter out work days from a isweekday column on my date table. I can't seem to get any of these suggestions to work.
Thanks!