Forum Discussion

Solution Sage

2 years ago

Solved

Networkdays not working?

Please have a look at this sample data :

Country	DCAF submitted	DCAF completed	Days to Approve	Test		Excel Calc	Remark
Saudi Arabia	14-08-24	15-08-24	1	2		1	No weekend
Ukraine	13-08-24	19-08-24	6	5		6	Weekend
Kazakhstan	21-03-24	26-03-24	5	4		5	Weekend
Iraq	15-08-24	19-08-24	4	3		4	Weekend
Bangladesh	16-08-24			-32515		-45520	x
Russia	23-08-24	27-08-24	4	3		4	Weekend

I am trying to exclude weekends between 2 dates.

The field "Days to Approve" is a normal DATEDIFF like :

Days to Approve = DATEDIFF(Tracker[DCAF submitted],Tracker[DCAF completed],DAY)

So for the network days I made the field 'Test' en set it up like :

Test = NETWORKDAYS(Tracker[DCAF submitted],Tracker[DCAF completed],1)

If you then for instance look at the last line the datediff gives 4 days.

27 -23 Aug is indeed 4 days.

But I would expect the Networkdays to return 2 and not 3....

And on the line which has no weekend in the Networkdays does something really strange.

Difference was 1 day without weekend so I would expect networkingdays to also return 1 but here it even adds a day!??

Does anybody have an idea where I am going wrong?

Only thing I want is to exclude the weekends between 'DCAF submitted' and 'DCAF completed'.

rpinxt
2 years ago
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.

5 Replies

Idrissshatila
Super User
2 years ago
Hello rpinxt ,

weird behaviour you're having here, I tried the networkdays and it shows 3 days

networkdays = NETWORKDAYS(DATE(2024, 8, 23), DATE(2024, 8, 27),1)

and the datediff as well
rpinxt
Solution Sage
2 years ago
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?
- Idrissshatila
  Super User
  2 years ago
  Hello,
  - rpinxt
    Solution Sage
    2 years ago
    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
rpinxt
Solution Sage
2 years ago
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.