Results 1 to 4 of 4
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Networkdays calcs (Excel2000SP3)

    Hi All

    I like the Excel function
    NETWORKDAYS(start_date,end_date,holidays)

    It's great (and simple) for calculating the number of actual working days between two dates.

    I have a named range for my holidays date list.

    But what I want to do is to find out:
    1. the date of the next working day that is x working days after a given date
    2. the date of the working day that was y days before a given date.

    It would be nifty to a have a fast function that could do this.
    For example, in column [A] I have a column of dates
    In column [b] I have the specified number of working days (e.g. 5, 12, 17, -8, -13, 22 etc)
    I'd like column [C] to have the relevant working day date.

    Has anyone already done this???

    zeddy

  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: Networkdays calcs (Excel2000SP3)

    Did you look at the =WORKDAY(start_date,days,holidays) function?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Re: Networkdays calcs (Excel2000SP3)

    That does exactly what I want!

    How did I miss that function!!!!

    many thanks

    zeddy

  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: Networkdays calcs (Excel2000SP3)

    The magic of the "See Also" button on the Help pages. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    -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
  •