Calculating Business Day intervals

[mbmccoy]

Using Access 2003, how do I calculate the interval between two dates in
business days and not straight calendar days.

 

[Rick B]

Do a search. Asked and answered about ten times a week in here.

 

[Graham R Seach]

'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