Excel Function Translator Logo
    The Excel Translator

    NETWORKDAYS.INTL

    Date & Time

    Returns the number of whole working days between two dates with custom weekend parameters. Like NETWORKDAYS but lets you specify which days of the week are weekends.

    Translations
    EnglishNETWORKDAYS.INTL
    FrenchNB.JOURS.OUVRES.INTL
    SpanishDIAS.LAB.INTL
    GermanNETTOARBEITSTAGE.INTL
    ItalianGIORNI.LAVORATIVI.TOT.INTL
    PortugueseDIATRABALHOTOTAL.INTL
    DutchNETWERKDAGEN.INTL
    PolishDNI.ROBOCZE.NIESTAND
    RussianЧИСТРАБДНИ.МЕЖД
    TurkishTAMİŞGÜNÜ.ULUSL
    CzechNETWORKDAYS.INTL
    HungarianÖSSZ.MUNKANAP.INTL
    SwedishNETTOARBETSDAGAR.INTL
    DanishANTAL.ARBEJDSDAGE.INTL
    FinnishTYÖPÄIVÄT.KANSVÄL
    Syntax
    NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

    Arguments

    • start_dateThe start date.
    • end_dateThe end date.
    • weekendOptional. Number 1-17 or a 7-character string of 0/1 indicating which days are weekend. 1 = Sat/Sun (default), 11 = Sun only, 7 = Fri/Sat, etc.(optional)
    • holidaysOptional. A range of dates to exclude as holidays.(optional)
    Examples
    =NETWORKDAYS.INTL("2026-01-01","2026-01-31")
    22

    Working days in January 2026 (Sat/Sun weekend)

    =NETWORKDAYS.INTL("2026-01-01","2026-01-31",7)
    22

    Counts working days with Friday/Saturday as weekend

    =NETWORKDAYS.INTL("2026-01-01","2026-01-31","0000011")
    22

    Custom weekend pattern: Saturday and Sunday off

    Tips & Best Practices
    • •Available since Excel 2010
    • •Use a 7-char binary string like "0000011" (Mon=position 1) for any custom weekend pattern
    • •Holidays are excluded only if they fall on a working day
    • •Useful for international payroll and HR scheduling
    Common Mistakes
    • •Using the numeric weekend codes (1-17) without checking Excel's reference table first - the numbers don't follow an obvious pattern, so guessing can easily select the wrong weekend definition
    • •Building the 7-character binary weekend string in the wrong day order - position 1 represents Monday, not Sunday, which trips up anyone assuming a Sunday-first week
    • •Forgetting that holidays are only excluded if they fall on what would otherwise be a working day - listing a date that's already a weekend day in the holidays argument has no additional effect
    Related Functions
    NETWORKDAYSUses a fixed Saturday/Sunday weekend, a simpler alternative when the standard convention already fits your needs.
    WORKDAY.INTLCalculates a resulting date from a starting date and a number of working days, the inverse operation of NETWORKDAYS.INTL's day-counting.
    WEEKDAYIdentifies which day of the week a single date falls on, useful for verifying which days your weekend code is actually excluding.
    Frequently Asked Questions

    How do I choose the right weekend code number?

    Check Excel's documentation table rather than guessing - the codes 1 through 17 map to specific weekend day combinations (like 1 for Saturday/Sunday, 7 for Friday/Saturday) that aren't in an intuitive order.

    What does the 7-character binary weekend string mean?

    Each character represents a day starting with Monday in position 1 through Sunday in position 7, where 1 means that day is a weekend day and 0 means it's a working day - so "0000011" marks Saturday and Sunday as weekends.

    Does listing a holiday that falls on a weekend change the result?

    No, holidays only get excluded from the count if they would otherwise be a working day - a holiday that already falls on a weekend has no additional effect on the total.

    Need to translate a formula using NETWORKDAYS.INTL?

    Use our translator to convert your complete formula