NetWorkDay function

[andremt.vianna]

How can I use the NetWorkDay Excel function on VBA?

The application.worksheetfunction does not work on this case because this function belongs to the add in 'atpvbaen.xls'.

Is there any I can use this function whithout having to code it my self?

 

[_PhilW_]

from memory, you just write "NETWORKDAYS(parameters)".
in the same way that some core functions are built into VBA, and some you have to use the application.worksheetfunction prefix.

Unfortunately, I've got 2007 now, so can't test.

hth

 

[_PhilW_]

oh, and you need to enable the reference in the VBA code. Tools > References > atpvbaen.xls

 

[andremt.vianna]

Sure! so simple! THANKS!