Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Detroit, Michigan, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    calculate weekdays between two dates (MS Excel 2000)

    I have two dates in a spread sheet and I am trying to calculate the number of days between the two days, but excluding weekend days. Any ideas on how to pull that off?

    Tom

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: calculate weekdays between two dates (MS Excel 2000)

    In Excel 97, there's a function called NETWORKDAYS. It may be part of the Analysis ToolPak. I'm not sure if it's different in Excel 2000, but if you go to ToolsAdd-Ins, you might see a check box for the 'Analysis ToolPak'.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: calculate weekdays between two dates (MS Excel 2000)

    As Chipshot says the correct command is NETWORKDAYS but it is a regular Excel command in 2000.

    NETWORKDAYS(start_date,end_date,holidays)

    NETWORKDAYS("10/01/1999","2/15/2000",{"12/24/1999","1/3/2000"}) excludes Dec 24, 1999 and Jan 3, 2000 and equals 96.

    Go to your Excel help page and type in NETWORKDAYS for more details.

Posting Permissions

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