Count down to a date

[pgarcia]

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

 

[Bernard Liengme]

Have a look at function WORKDAY
best wishes

 

[pgarcia]

Thanks, after looking around, I went with NETWORKDAYS. So if anyone is
reading this:
I used =TODAY()-1 (I'm not counting today), then using the DATE function I
used my end date, in this case 8/4/2009.

=NETWORKDAYS(R61,R62) = 12

 

[Shane Devenshire]

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(EOMONTH(NOW(),0)+2,2)>5)+(WEEKDAY(EOMONTH(NOW(),0)+2,2)=6),H1:H4)

In this case I have allocated H1:H4 for Holidays.