Hello all,
My boss is looking for a count down to a "closing" date. At the end of the
month we close our A/R books and I have report that shows him how much is
outstanding to applie. Ok, so he is want so see how many working days we
have, this month is 23-1 do to the holiday so we have 22 days. Our closing
day falls two days after the last working day. So it would fall on Aug 2, but
because Aug 1-2 are weekends, our closing day is Aug 4. Did I lose you? Ok.
This is what it should look like.

Working days = 22, days tell closing = 12

Looking for a formula. Thanks