by NoSparks » Sat Jul 12, 2014 5:27 pm
I directed you to the link in my previous post as a polite way of saying
DON'T CROSS POST UNLESS YOU ARE GOING TO DO IT IN A RESPECTABLE MANNER
not as an encouragement to post the same question in another forum, which you had already done.
That is a page numerous Excel forums refer members to for an understanding of why cross posting is considered a No-No.
Now, back to your question, obviously you don't agree with my view of the problem, so maybe I'm misunderstanding something. Believe it or not I am trying to help you.
On your final sheet, for row 7 where your Document No. is TEST6, from your source sheet, what Invoice Date should be going into cell E7? and how do you know that?
With what you have now in E7 the value of -5 in cell F7 is correct because the invoice date is earlier than the scan date.
If it doesn't matter which was first, the scan date or the invoice date, then =ABS(NETWORKDAYS(D7,E7)) will always give a positive number.