Results 1 to 2 of 2
  1. #1
    Asmar
    Guest

    Calculating Business Days

    Guys & Gals,

    I'm working a project and need to calculate business days from two dates, start date and end date. The dates already reside in s spreadsheet. Is there a formula or macro that will provide this info without manually counting the days??

    Asmar

    Pls respond privately jwpang@att.com

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Business Days

    Yep, there's a function to do it. First, you need to install the Analysis toolpack (Tools, Addids, Analysis toolpack). Then use the formula "=networkdays(startdat,enddate[,holidays])"
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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