VBA version of "Networkdays"?

[Darth269]

Hi folks,

I'm looping through an array, making various checks of the data, and for this particular part I'm looking at a date, and finding out how many days before another date it was (not including weekends).

I'm wondering if I'm forced to use "application.worksheetfucntion.networkdays", or if there is a vba equivilent?

I'm led to believe that doing this across several thousand rows of data is likely to slow the code...

[Darth269]

Actually, I think i have a solution in this case. The "48 hours previous" date in this report is static, and I've simply set it as a variable once, at the start of the code, then I can do a compare. However, my question stands, is there a way to work this out in code, without having to reference the worksheet functions each time?

future reports might not work with a static date like in this case so it would be handy.

[karedog]

This UDF MyNetworkdays() perform 15x faster than Excel builtin NetworkDays() function :
(0.14 seconds vs 2.29 seconds)

Please Login or Register  to view this content.

[Richard Buttrey]

On my 64 bit Dell XPS with an i7 10th generation chip I can detect no discernible difference in speed.

I'm therefore surprised since it's always been my understanding that the slowest part of any VBA functionality is the reading and writing stuff from the Excel App to VBA and then back to Excel.

I'm also surprised since if this is true it means the designers of the Networkdays function have not been as efficient in using the interface to the underlying machine code, which is presumably the same for the Excel function and VBA.