Whats the equivalent for NETWORKDAYS in VBA for excel ?

  • Thread starter Thread starter sorabh
  • Start date Start date
S

sorabh

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 !
 
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 >
 
Back
Top