Forum Discussion
Networkdays not working?
Well thinking a bit more about this I think that it is in the way both dax formulas work:
If you take the last line and look at DateDiff then you can say 27 -/- 23 is 4 so that is correct.
But if you would count the days it would be 23, 24, 25, 26, 27 so then it would be 5.
But Networkdays does not look at the difference but really counts that days.
23, 26 and 27 = 3 days.
Therefore I think the formulas work fine.
Just up to me (us) to see what we would need.
The difference in the days or really count the days literally.
And I can always do -1 with networkdays if we need to count the days between dates without weekends.
Instead of litteraly counting all the days without weekends.
Idrissshatila well I think it is.
But you are typing the date in the formula.
What if you copy my sample data in Excel.
And then make the calculated columns like I did.
Do you get the same?
Hello,
Ok so you get the same.
Yes I think it is just how it works.
As explained in previous post we will make it work for us.
Thanks for your replies Idrissshatila