SOLVED: Function needed for business days

[TonyJollans]

babsc01 - that routine takes in an array of holidays, something like ..

[VBA] Dim Holidays(2) as Date
Holidays(0) = #01 Jan 2004#
Holidays(1) = #25 Dec 2004#
Holidays(2) = #26 Dec 2004#
[/VBA]
Then call like ..

[VBA] NetWorkDays(StartDate, EndDate, Holidays)[/VBA]
.. or without declaring your own array, you can just do ..

[VBA]
NetWorkDays(StartDate, EndDate, Array(#01 Jan 2004#, #25 Dec 2004#, #26 Dec 2004#))
[/VBA]

Seems little point in me knocking anything up now