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!