Excel 2007 : Calculating Networkdays

[Danno_74]

Help....I need to calculate the days between a agreed due date and received date but am having problems where the recieved date is before the due date. Here is the formular I have been using =IF(D4>C4,NETWORKDAYS(C4,D4)-1,(D4-C4))

Examples: Cell C4 (due date) is 01/07/2010 and cell D4 (received date) is 08/07/2010 the result is 5

but if

Cell C4 (due date) is 08/07/2010 and cell D4 (received date) is 01/07/2010 the result is -7.

Thanks in advance for your help.

[DonkeyOte]

perhaps you want:

=SIGN(D4-C4)*(NETWORKDAYS(MIN(C4:D4),MAX(C4:D4))-1)

[Danno_74]

That is great, thanks so much.