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...
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(......))
=if(A2=B2,1,NETWORKDAYS(......))
Hello Mr. JKP,
I have updated my question can you kindly let me know if you have any clue ?
I have updated my question can you kindly let me know if you have any clue ?