Networkdays formula

Hi, does anyone know the formula for subtracting one date from another date, but only counting business days. I know you can use the NETWORKDAYS formula, but here is a twist - if you subtract 8/26/13 from 08/27/13 the formula would spit out 2. How do you make it so it spits out 1 day?
Another example, subtract 8/22/13 from 8/26/13 and the answer should be 2 (weekend was subtracted).
Thank you!

Try

=NETWORKDAYS(A1+1,B1)

A1 = Begin Date, B1 = End Date.

That works, gracias!

You're welcome.

Actually wait. I found a hole in the formula. If both of the dates are the same, the result is a -2, not 0. ???????

Yep, this is a core difference between NetworkDays and just plain old B1-A1
Networkdays INCLUDES both start and end date, while B1-A1 excludes 1 of them.

Try
=MAX(0,NETWORKDAYS(A1+1,B1))

Thank you! Let me ask you another question - is there a way to make this formula spit out a negative number. Let's say that the start date comes after the end date...?

A negative number of days?
That doesn't really make sense to me (or to Excel)

I think at best we can reverse the dates so the earliest date is always first...
Then multiply by 1 or -1 depending on which Date was greatest..

=MAX(0,NETWORKDAYS(MIN(A1,B1)+1,MAX(A1,B1)))*IF(A1>B1,-1,1)

You are very close, sir. Thank you, but there is one issue, let's say the date in is 8/25/13 and date out is 8/27/13. The count should be 1 day (right now it is 2) as Sunday does not count and it is one day from Monday to Tuesday. Any ideas? Thanks so much for all your help so far.

I don't know, this is getting a bit too complex for me I think..

But I have to ask...
How can an event End Before it Starts?
If a Start date is on a weekend, I would think Weekends should be included...