Count down to a date
 

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

Count down to a date
 

Have a look at function WORKDAY
best wishes
--
Bernard Liengme
Microsoft Excel MVP

http://people.stfx.ca/bliengme
"pgarcia" wrote in message
...
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

Count down to a date
 

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

"Bernard Liengme" wrote:

Have a look at function WORKDAY
best wishes
--
Bernard Liengme
Microsoft Excel MVP

http://people.stfx.ca/bliengme
"pgarcia" wrote in message
...
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

Count down to a date
 

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