| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Whats the equivalent for NETWORKDAYS in VBA for excel ?
Guyz
please help me out on this one. when i wanted to calculate business days between two dates i could do that with networkdays function but what can i use if i m writing a macro, is there some direct function in VBA or there is some roundabout ? i have heard of WORKDAY but when i typed it in help ( with VBA edito open) i didnt get anything. help needed urgently ! -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Whats the equivalent for NETWORKDAYS in VBA for excel ?
it's a function from analysis toolpak.
for vba you'll also need to enable the addin "analysis toolbak VBA" THEN you set a reference to that project and you should have your NETWORKDAYS.. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool sorabh wrote: Guyz please help me out on this one. when i wanted to calculate business days between two dates i could do that with networkdays function but what can i use if i m writing a macro, is there some direct function in VBA or there is some roundabout ? i have heard of WORKDAY but when i typed it in help ( with VBA editor open) i didnt get anything. help needed urgently !! --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Whats the equivalent for NETWORKDAYS in VBA for excel ?
Try here for a posting by Norman Harker
http://tinyurl.com/2t6t9 or http://tinyurl.com/yrzfe -- Don Guillett SalesAid Software "sorabh " wrote in message ... Guyz please help me out on this one. when i wanted to calculate business days between two dates i could do that with networkdays function but what can i use if i m writing a macro, is there some direct function in VBA or there is some roundabout ? i have heard of WORKDAY but when i typed it in help ( with VBA editor open) i didnt get anything. help needed urgently !! --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1-4-1 is not a date how do I stop excel from changing whats enter | Excel Worksheet Functions | |||
| I wanted to TRY EXCEL, whats this - Business OFFICE???? ugh | Excel Discussion (Misc queries) | |||
| Networkdays equivalent for minutes | Excel Worksheet Functions | |||
| excel SUM function - can it be limited to whats in parentheses? | Excel Discussion (Misc queries) | |||
| whats the keyboard short cut for inserting a row in Excel | New Users to Excel | |||
Linear Mode
