+ Reply to Thread
Results 1 to 5 of 5

Networkdays.intl

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Goiânia, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Networkdays.intl

    Hello. I would like to count how many "work" Fridays there in between two dates. I thought about use the NETWORKDAYS.INTL function and string value to determinate Friday as the only workday at the week: 1111011. But then I got an #NÚM. I guessed that's because the strings values could not lead to errors only if they match some of the given options of custom weekends of the formula (like "16 - only Fridays" as weekend; by the way the opposite of what I want). So I simulated the strings values for many of the options, like 0000010 that should be equal to "17 - only Saturday", but again I got an #NÚM. So I have no idea how to use string value input for the custom weekends on the NETWORKDAYS.INTL function.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Networkdays.intl

    Please post the formula you're attempting to use (even if it doesn't work)
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Networkdays.intl

    Make sure you're entering that 1111011 as a TEXT STRING..with Quote marks
    i.e.
    "1111011"

  4. #4
    Registered User
    Join Date
    08-19-2014
    Location
    Goiânia, Brazil
    MS-Off Ver
    2010
    Posts
    5

    Re: Networkdays.intl

    I was entering the custom weekend through a cell reference: =DIATRABALHOTOTAL.INTL(B3;C3;A3;Feriados!$A$1:$A$54). So, at the cell A3 I put 1111011 without quote marks and thhen I got a #NÚM, inside the quote marks I got a #VALUE!. But using the apostrophe it worked, that's how I solved: '1111011. Inside the formula the correct way is use the quote marks like Jonmo1 said. Thanks everybody for all.

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Networkdays.intl

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with Workday.intl
    By NeedForExcel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-30-2015, 07:01 AM
  2. [SOLVED] Networkdays.Intl, incorrect result in one row
    By razaas in forum Excel General
    Replies: 1
    Last Post: 10-22-2014, 07:04 AM
  3. Workday.intl problems
    By JacoKanban in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2013, 06:40 PM
  4. Workday.intl function--Holidays help
    By bluskye425 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2013, 02:28 PM
  5. [SOLVED] Looking for alternative to NETWORKDAYS.INTL
    By Jaron_t in forum Excel General
    Replies: 4
    Last Post: 05-21-2012, 04:54 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1