Re: Working Days Remaining in Month, Working Days Remaining in Year

Hi,

Patrick A wrote:
All,

Can anyone point me to a good explanation of the proper way to go
about calculating the number of WORKING days between;
A: Date() and the last day of the current month
B: Date() and the last day of the current year

So far the closest I have gotten to B: is (DateDiff("D",Date
(),#12/31/2009#)*0.71429)

But I would love to be able to do this more accurately and without
having to change #12/31/2009# to #12/31/2010# while I am suffering
from a hangover.

If holidays can be taken into consideration, great, but not absolutely
necessary.

You could take a look at the < DirectDateFunctions > available as a textfile
or sample database here :

http://personalwebs.oakland.edu/~fortune/

Regards
Jens



.

Relevant Pages

  • Working Days Remaining in Month, Working Days Remaining in Year
    ... Can anyone point me to a good explanation of the proper way to go ... about calculating the number of WORKING days between; ... If holidays can be taken into consideration, great, but not absolutely ...
    (comp.databases.ms-access)
  • Re: Working Days Remaining in Month, Working Days Remaining in Year
    ... Can anyone point me to a good explanation of the proper way to go ... about calculating the number of WORKING days between; ... If holidays can be taken into consideration, great, but not absolutely ...
    (comp.databases.ms-access)
  • Re: Attn Court1: Rafas knee status
    ... When I read a simple explanation, I will let you know, until then all ... you and Patrick are skirting around my question which is how ... difficult or painful - depending on the type and seatig of the jetski. ...
    (rec.sport.tennis)
  • Re: Word 2007 Font.Color fun
    ... of the proofficedev explanation but not part 2. ... would be one thing if they decided to upgrade their colour system to proper ... Is there rational explanation for why the colour system had to be ...
    (microsoft.public.word.vba.general)
  • Re: (bsd)tar is broken on 6.1
    ... Patrick M. Hausen wrote: have the explanation: ... the tar-writing code that causes it to ... (The 1 here enables the above-mentioned ...
    (freebsd-stable)