[AccessD] Calculating DateDiff for Workdays

Gary Kjos garykjos at gmail.com
Tue Jan 10 10:23:36 CST 2006


AccessWeb has a solution for Number of Workdays

http://www.mvps.org/access/datetime/date0006.htm

Have a look.  There are two solutions posted, one counts weekdays with
no allowing for holidays and the other factors in holidays but
requires a table listing the holidays.

Good luck!

Gary


On 1/10/06, Terri Jarus <jarus at amerinet-gpo.com> wrote:
> I've found a function in the archives "DiffBusinessDays_TSB" which references DiffWeekdays_TSB - however, I'm unable to locate that function.
>
> I need to set up a formula to calculate the difference between two dates - but only wish to count Business days - no weekends.
>
> Thanks for any help.
>
> Terri Jarus
> Vice President, Contract Services
> jarus at amerinet-gpo.com
> 314-542-1902
>
>
> ---------------------------------------------------------------------------
> This email and any files transmitted with it are intended solely for the use of the individuals or entities to whom they are addressed and are not to be disclosed to any other party. If you have received this email in error please return it to the sender, and erase any copies thereof.
> ---------------------------------------------------------------------------
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list