CODEWITHSUNDEEP
excelexcel-formula
Gerry
Gerry

Reputation: 127

Excel NETWORKDAYS - Do these returned values look more reasonable?

Do these returned values look more reasonable for NETWORKDAYS?

2013/6/26 Wed
2013/6/27 Thu
2013/6/28 Fri

=NETWORKDAYS("2013/6/27","2013/6/26") = -2

Should above better return -1?

=NETWORKDAYS("2013/6/27","2013/6/27") = 1

Should above better return 0?

=NETWORKDAYS("2013/6/27","2013/6/28") = 2

Should above better return 1?

Upvotes: 1

Views: 1105

Answers (1)

GregHNZ
GregHNZ

Reputation: 8989

No, if you worked on the 27th, you'd say your start day is the 27th, your end day is 27th, and net days is 1.

Seems perfectly valid for me.

Upvotes: 1

Related Questions