Calculating Workdays in an Interval

[roadkill]

It seems like there should be a simple way in VBA to determine the number of
workdays in an interval (short of looping to count them or using DateDiff
then subtracting out weekends and holidays). Unfortunately I haven't been
able to find it. Am I missing something? Is there, per chance, a function
similar to Datediff that will provide what I need in one step?

Thanks,
Will

 

[Jan De Messemaeker]

Hi,

You need the DateDifference method (application.date difference)
HTH

 

[roadkill]

Thank you. That takes care of it.
- Will

Hi,

You need the DateDifference method (application.date difference)
HTH