Forum Discussion
Solved
Getting #value! error while using networkdays formula how to get rid of that?
It can be seen I used the same formula in all cells some cell return values and some doesnt.
and also A3 & B3 are same dates but return value is 0. while A4&B4, A9&B9, A10&B10 shows the return value as 1. can any one clarify this to me ?
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.
4 Replies
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.
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.
- depends on your expected answer. if same day must equal 1:
=if(A2=B2,1,NETWORKDAYS(......))- Hello Mr. JKP,
I have updated my question can you kindly let me know if you have any clue ?
