Results 1 to 10 of 10
  1. #1
    Lounger
    Join Date
    Mar 2009
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dear all,

    I am facing a proble while calculating the variance in my data sheet.

    I need to calculate the variance (difference) of days between the planned days and actual days spent to perform a task.

    I need to perform the functions only on weekdays (i.e Mon to Fri),that is, I want the variance, excluding the weekends.

    Is it possible to activate this feature, that while doing calculations only weekdays should be considered.

    Is there any way to do this .

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you activate the Analysis ToolPak add-in (in Tools | Add-Ins...), you can use the NETWORKDAYS function. This calculates the number of working days between two dates (optionally excluding holidays too).

  3. #3
    Lounger
    Join Date
    Mar 2009
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts
    But there is no such option in Word 2003 in ToolPak Add-ins.

    How do i get this fumction NETWORKDAYS in Add-ins.

    [quote name='HansV' post='778756' date='08-Jun-2009 16:35']If you activate the Analysis ToolPak add-in (in Tools | Add-Ins...), you can use the NETWORKDAYS function. This calculates the number of working days between two dates (optionally excluding holidays too).[/quote]

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You asked a question in the Excel section, which is why you got an Excel answer.
    I'd advise you to do this calculation in Excel.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Jan Karel Pieterse already mentioned that you asked your question in the Excel forum.

    Although you can perform date calculations in Word (see post 249902) and mathematical calculations too (see post 365442, Excel is far better in that respect. If necessary, you can embed or link an Excel sheet in your Word document.

  6. #6
    Lounger
    Join Date
    Mar 2009
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am extremely sorry for mistyping, I meant there is no such option in Excel 2003.

    NETWORKDAYS function is not in the list of Add-ins.

    [quote name='pieterse' post='778762' date='08-Jun-2009 17:44']You asked a question in the Excel section, which is why you got an Excel answer.
    I'd advise you to do this calculation in Excel.[/quote]

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='abhilasha' post='778919' date='08-Jun-2009 21:31']I am extremely sorry for mistyping, I meant there is no such option in Excel 2003.

    NETWORKDAYS function is not in the list of Add-ins.[/quote]
    You will need to install the Addin first. Then the function will be available.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  8. #8
    Lounger
    Join Date
    Mar 2009
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How can I install Add-ins?

    Do I need to re-install Excel?

    [quote name='WebGenii' post='778922' date='09-Jun-2009 09:47']You will need to install the Addin first. Then the function will be available.[/quote]

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    NETWORKDAYS is not an add-in, it is the name of a worksheet function that is not available by default.

    The name of the add-in is Analysis ToolPak. See Load the Analysis Toolpak.
    When you have loaded it, several extra worksheet functions can be used in formulas, among which NETWORKDAYS.

  10. #10
    Lounger
    Join Date
    Mar 2009
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post

    Hey, thank you so much guys.

    You all were of great help....



    [quote name='HansV' post='778927' date='09-Jun-2009 11:37']NETWORKDAYS is not an add-in, it is the name of a worksheet function that is not available by default.

    The name of the add-in is Analysis ToolPak. See Load the Analysis Toolpak.
    When you have loaded it, several extra worksheet functions can be used in formulas, among which NETWORKDAYS.[/quote]

Posting Permissions

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