Forum Discussion
Getting #value! error while using networkdays formula how to get rid of that?
Hi Dinesh,
NETWORKDAYS() returns #VALUE if any of date is incorrect. It looks like in your locale dates are in MM/DD/YYYY and dates as 28/11/2017 are incorrect (month=28, day=11).
On the other hand such dates shall be aligned to the left as text, on your screenshot they are not. Anyway, better if you attach small sample file.
Dinesh, Sergei has explained the problem with your date formats not matching the requirements for your locale which is causing the #value errors. The reason you are getting different results for the number of net working days when the start date is equal to the end date is that all but one case the accepted date is a working day and therefore returns 1 and in the case where 0 is returned the day is a on a weekend and therefore not counted as a week day. 12th February 2017 is a Sunday. Now because of the date problem 12th February may have intended to be 2nd December which is a Saturday and so would have given the same 0 return. This may not be the case for the other dates. You need to fix that problem first.