Count Business Days

[David]

Is there a function similar to networkdays in Excel?

Basically count the number of business days between startdate and enddate.

Thank you,

David

 

[Graham R Seach]

David,

'Number of weekdays between two dates (by Doug Steele MVP)
myInt = DateDiff("d", dte1, dte2) - _
DateDiff("ww", dte1, dte2, 1) * 2 - _
IIf(Weekday(dte2, 1) = 7, _
IIf(Weekday(dte1, 1) = 7, 0, 1), _
IIf(Weekday(dte1, 1) = 7, -1, 0))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[David]

Graham,
Not sure how it works, but it's perfect.

Thank you,
David

 

[Graham R Seach]

<<Not sure how it works, but it's perfect.>>
Call it "Steele magik".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html