Networkdays

[XLS-EXCEL]

Hi All

From the following formula I want to work out that:

=IF(OR(K8,X8=""),"",NETWORKDAYS(K8,J8)+NETWORKDAYS(N8,X8))-SIGN(NETWORKDAYS(K8,J8)N8,X8))

If K8 or X8 are empty then leave this blank

other wise

Workout the NETWORKDAYS between the dates in K8 and J8

and ADD it to the

the number of networdays between the dates in N8 and X8.

the -Sign.... is to say that if the result if NEGATIVE then display as a MINUS or if positive then leave as normal.

Any ideas how I could do this?

Thanks!