Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Orange Cty New York
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    calculating business days (excel 2000)

    how would I go about creating a formula that would calculate the amount of business days between two dates?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: calculating business days (excel 2000)

    One already exists:

    =NETWORKDAYS(start_date,end_date,range_list_of _holidays)

    it assumes that Saturday and Sunday are not workdays.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: calculating business days (excel 2000)

    John: You probably should have mentioned that NETWORKDAYS is part of the Analysis Toolpak addin that is not installed by default. The user will have to install it if it is not already installed.
    Legare Coleman

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: calculating business days (excel 2000)

    Arrrgh! <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> I always forget which functions are in the Toolpak. Thanks for the reminder.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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