Business day difference between 2 dates
 

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

Business day difference between 2 dates
 

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*" wrote in message
...
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

Business day difference between 2 dates
 

=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*" wrote in message
...
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

Business day difference between 2 dates
 

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" wrote in message
...
=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*" wrote in message
...
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

Business day difference between 2 dates
 

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

Business day difference between 2 dates
 

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" wrote in message
...
=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*" wrote in message
...
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