Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Work days (2002)

    Another request for the Loungers. I often get reports that provide information on the number of workdays. These normally come in two formats - 1)Number of working days, or 2) to/from dates.

    I'm trying to work out a way to:-
    1) Calculate the 'to' date based on the number of working days stated, &
    2) Calculate the number of working days based on the 'to/from' dates.

    I hope that make sense - any thoughts

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Work days (2002)

    There are two functions in the Analysis Toolpack addin that will give you exactly what you are asking for. If you give the Workday function a start date, number of days, and a list of holidays, it will return the date serial number of "to" date. If you give the NETWORKDAYS function a start date, end date, and a list of holidays, it will return the number of workdays between the two dates.

    If you do not have the analysis toolpack installed (it comes with Excel), you will need to install it before using these functions.
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Work days (2002)

    Legare - you've done it again!! Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •