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/