count workdays

  • Thread starter Thread starter buddy
  • Start date Start date
B

buddy

is there a built in function in access that will count
workdays, exculding holidays that i designate? i know
excel has a workday function. is there something along
those lines in access?
 
Buddy,

There's also this; created by Doug Steele MVP:

intWorkDays = 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
 
Back
Top