Calculating "business days" for Access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of an EASY way to calculate the number of "business days"
between 2 dates for an Access report? Preferably the expression would also
exclude holidays. Theoretically, there is a listing of national holidays
somewhere in the Outlook files that we ought to be able to use (either
directly or through an import) to exclude these days from the "business days"
calculation, but I can't find it.
 
Define "easy". You can use this formula to count the "business days" (if you
mean M-F) between two dates. Excluding holidays gets really nasty but you
could create a holiday table and count the number of rows that fall between
your dates.

(datediff("w",[date1],[date2])*5)+(6-(datepart("w",[date1]))

The first part figures the number of full work weeks between the two dates
and multiplies by 5 (workdays in a week). Then it adds the number of
workdays after date1 in the first week.

This depends on both dates being weekdays as well. And I don't know if you
call this easy or not.
 
Back
Top