Datediff without Weekends

Asked Sep 29 '14 at 11:38

Active Sep 29 '14 at 12:00

Viewed 111 times

A short explanation what I do: I have a chart, where i show a Label for the Min and Max Value. If the appropriate Extrema are on the right side of the chart, the Label is aligned left. (If it's left, then the label is aligned right) The Y-Axis has timestamsp, so I calculate the Datediff, to align the Label.

minPos = (minTupel.Value.Time - srtTupel.Value.Time) 
          > (endTupel.Value.Time - minTupel.Value.Time) 
          ? "Left" : "Right";

maxPos = (maxTupel.Value.Time - srtTupel.Value.Time) 
          > (endTupel.Value.Time - maxTupel.Value.Time) 
          ? "Left" : "Right";

But the chart ignores the weekends, because there are no values. If I calculate the difference between Thursday and Monday, the result is 4 Days, but the chart only shows 2. Therefore the label is aligned right, when it should be left. Is there any option to get the Datediff without the Weekends?

edited Sep 29 '14 at 12:00

Mukund

1,679
1
11
20

asked Sep 29 '14 at 11:38

Matthias Seifert

2,033
3
29
41

Just assume that any contiguous 7-day period will contain two weekend days, and then handle the edge case of < 7 days by looking at the day of week of each date. – Keith Payne Sep 29 '14 at 11:43
This could easily escalate to a complex matter. What about holidays that are not on weekends? – Steve Sep 29 '14 at 11:43
2

@Steve The dupe I linked handles holidays too – DavidG Sep 29 '14 at 11:45
@DavidG yes I was just looking at it, great answer. Closing this now – Steve Sep 29 '14 at 11:46
@Steve I don't see holidays in this question. Maybe the linked answer is overkill. – Keith Payne Sep 29 '14 at 11:47
1

@KeithPayne it is really easy to adapt – Steve Sep 29 '14 at 11:48
Thanks! I haven't found this question in the search, but it really saves me time. – Matthias Seifert Sep 29 '14 at 12:11

Datediff without Weekends

0 Answers0