Hi,

The following formula will return the number of day from the current date
requiring no reference cells:

=NETWORKDAYS(NOW(),EOMONTH(NOW(),0)+2+(WEEKDAY(EOM ONTH(NOW(),0)+2,2)5)+(WEEKDAY(EOMONTH(NOW(),0)+2, 2)=6),H1:H4)

In this case I have allocated H1:H4 for Holidays.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pgarcia" wrote:

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