=IF(B1<A2,NETWORKDAYS(A2,B2),NETWORKDAYS(B1,B2))-1
In B3 where your ranges are in A1:A2 and B1:B2
Crude I know
--
Russell Dawson
Excel Student


"Colin" wrote:

Hello,

Can anybody help please?

I have used Networkdays() to count the working days between two dates. And
have had to do this twice. So now have two counts that I will add together.

But if the same particular date is in both count sets I dont want to count
it twice?

Hope this makes sense,

Thanks in advance