Business day difference between 2 dates

[Rock*]

Is there a pre-defined VB function to compute the count of the business days
between any 2 given days?

Thank you for your help.
--
Diana

[STEVE BELL]

Try this link -

http://groups-beta.google.com/group/...6ac39a62717ce1

It shows an attempt at replacing the worksheet function NetWorkDays with
code.
--
steveB

Remove "AYN" from email to respond
"Rock*" <Rock@discussions.microsoft.com> wrote in message
news:C4BF0082-2900-4640-B8CB-F9659CFE9376@microsoft.com...
> Is there a pre-defined VB function to compute the count of the business
> days
> between any 2 given days?
>
> Thank you for your help.
> --
> Diana

[Bob Phillips]

=NETWORKDAYS(date1,date2)

you can even include a list of holidays

=NETWORKDAYS(date1,date2, holidays)

This needs the Analysis Toolpak installed.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rock*" <Rock@discussions.microsoft.com> wrote in message
news:C4BF0082-2900-4640-B8CB-F9659CFE9376@microsoft.com...
> Is there a pre-defined VB function to compute the count of the business
days
> between any 2 given days?
>
> Thank you for your help.
> --
> Diana

[Bob Phillips]

Sorry meant to add that to use it in VBA, add a reference to the toolpak,
APTVBAEN.XLS, and call it like so

Debug.Print NETWORKDAYS(Range("M1"), Range("N1"), Range("holidays"))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23yJZiOyjFHA.1504@TK2MSFTNGP10.phx.gbl...
> =NETWORKDAYS(date1,date2)
>
> you can even include a list of holidays
>
> =NETWORKDAYS(date1,date2, holidays)
>
> This needs the Analysis Toolpak installed.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Rock*" <Rock@discussions.microsoft.com> wrote in message
> news:C4BF0082-2900-4640-B8CB-F9659CFE9376@microsoft.com...
> > Is there a pre-defined VB function to compute the count of the business
> days
> > between any 2 given days?
> >
> > Thank you for your help.
> > --
> > Diana
>
>

[Rock*]

Thank you very much!
--
Diana


"Bob Phillips" wrote:

> Sorry meant to add that to use it in VBA, add a reference to the toolpak,
> APTVBAEN.XLS, and call it like so
>
> Debug.Print NETWORKDAYS(Range("M1"), Range("N1"), Range("holidays"))
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:%23yJZiOyjFHA.1504@TK2MSFTNGP10.phx.gbl...
> > =NETWORKDAYS(date1,date2)
> >
> > you can even include a list of holidays
> >
> > =NETWORKDAYS(date1,date2, holidays)
> >
> > This needs the Analysis Toolpak installed.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Rock*" <Rock@discussions.microsoft.com> wrote in message
> > news:C4BF0082-2900-4640-B8CB-F9659CFE9376@microsoft.com...
> > > Is there a pre-defined VB function to compute the count of the business
> > days
> > > between any 2 given days?
> > >
> > > Thank you for your help.
> > > --
> > > Diana
> >
> >
>
>
>

[Rock*]

Thank you, I appreciate your help.
--
Diana


"Rock*" wrote:

> Is there a pre-defined VB function to compute the count of the business days
> between any 2 given days?
>
> Thank you for your help.
> --
> Diana