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 >
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use workdays or networkdays in VBA 3
how does one use the NETWORKDAYS function in a excel VB macro? 7
NetWorkDays in VBA? 5
NetWorkdays Not Recognized in 2007 4
using Networkdays formula in French version of Excel options 2
NETWORKDAYS function? 1
NETWORKDAYS 1
Problem using VBA for the Networkdays function 11

Back
Top