Working Days Only

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

Guest

I have the Work Days function working well as described on the MS site. The problem is that the "Office Closed" function will not work for me or I must be using it wrong. Please expalin to me how I can get the working days between 2 dates and EXCLUDE holidays as well. I cannot get the Office Closed function to work and the http://www.mvps.org/access/datetime/index.html isn't anymore helpful than the KB site. Please help me out and I promise to praise your name everytime I use the working function.
 
Have you looked at the workday Math function on the mvps site?

I changed this slightly so that it does a DLookup on a table to of holidays
and goes to the next day if one is found.

If anyone knows how to set the array of holidays in the code that is on the
site, based on a table - please enlighten me.

HTH

Caesar said:
I have the Work Days function working well as described on the MS site.
Click to expand...
The problem is that the "Office Closed" function will not work for me or I
must be using it wrong. Please expalin to me how I can get the working days
between 2 dates and EXCLUDE holidays as well. I cannot get the Office
Closed function to work and the
http://www.mvps.org/access/datetime/index.html isn't anymore helpful than
the KB site. Please help me out and I promise to praise your name everytime
I use the working function.
 
Back
Top