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

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/

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/