| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove non-business days between dates | Excel Discussion (Misc queries) | |||
| Calculate business days between 2 dates | Excel Discussion (Misc queries) | |||
| Calculate business Dates | Excel Discussion (Misc queries) | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| How do I find how many business days are between two dates | Excel Worksheet Functions | |||
Linear Mode
