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