Networkdays

Not quite sure what you mean about sign but perhaps you want this

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

VBA NOOB

It was not working so I put some extra brackets and now it works!

I guess extra brackets without your solution would have been pointless so THANK YOU!

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

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

?! (didnt think it would make a diff but I guess it does)

DLL I havent tried yours but I guess the above one works so its cool!

Thanks guys!

Regards

I am so sorry!

You know I have been up to my neck in work today and when you have people breathing down your neck it kind of cramps your style.

THANKS NBV!!

Apologies once again!

Kindest Regards