Results 1 to 3 of 3
  1. #1
    chkote
    Guest

    Date Calculations

    Hello all,
    I am trying to track down a method of subtracting one date from another and have the result show the number of days excluding weekends....any help will be much appreciated.
    Thanks

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Calculations

    There is a worksheet function called Networkdays that will return the number of working days between two dates. It is in the Analysis Toolpack, so if it is not available you need to go to Tools>Add-ins and turn the Analysis ToolPack on. See the online help for further info, or give us a yell if it doesn't work.

    Jon

  3. #3
    chkote
    Guest

    Re: Date Calculations

    Thanks Jon......that did the trick.

Posting Permissions

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