Business Days
Business Days
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Business Days

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to subtract one date from another, in business days only.
    (excluding weekends,holidays)

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help topic for "NETWORKDAYS worksheet function".

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I do not have function NETWORKDAYS available. I went to tools, data analysis to install, but it isn't there. What now?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 15:13, Kerri55 wrote:
    I do not have function NETWORKDAYS available. I went to tools, data analysis to install, but it isn't there. What now?
    Go to Tools | Add-Ins...

    Is there an entry in the list for Analysis ToolPak? If so, check it and press [ OK ].

    [ This Message was edited by: Mark W. on 2002-04-10 15:17 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I have access to the function. It wasn't in the tools, add in, analysis toolpack. I typed NETWORKDAYS, then selected the function button, and presto! Thanks for your help Mark.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com