Excel Function Translator Logo
    The Excel Translator

    NETWORKDAYS

    Date & Time

    Returns the number of working days between two dates (excludes weekends).

    Translations
    EnglishNETWORKDAYS
    FrenchNB.JOURS.OUVRES
    SpanishDIAS.LAB
    GermanNETTOARBEITSTAGE
    ItalianGIORNI.LAVORATIVI.TOT
    PortugueseDIATRABALHOTOTAL
    DutchNETTO.WERKDAGEN
    PolishDNI.ROBOCZE
    RussianЧИСТРАБДНИ
    TurkishTAMİŞGÜNÜ
    CzechNETWORKDAYS
    HungarianMUNKANAPOK
    SwedishNETTOARBETSDAGAR
    DanishANTAL.ARBEJDSDAGE
    FinnishTYÖPÄIVÄT
    Syntax
    NETWORKDAYS(start_date, end_date, [holidays])

    Arguments

    • start_dateThe start date
    • end_dateThe end date
    • holidaysRange of dates to exclude(optional)
    Examples
    =NETWORKDAYS(A1,B1)
    Working days

    Working days between two dates

    =NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))
    Days left this month

    Working days until month end

    =NETWORKDAYS(A1,B1,Holidays)
    Minus holidays

    Excludes holiday dates

    Tips & Best Practices
    • •Excludes Saturdays and Sundays by default
    • •Include holiday range for complete accuracy
    • •Use NETWORKDAYS.INTL for custom weekends
    Common Mistakes
    • •Forgetting to supply a holiday list, which makes NETWORKDAYS count public holidays as working days since it only excludes weekends by default
    • •Assuming NETWORKDAYS excludes Saturday and Sunday specifically, when your actual work week has different days off - use NETWORKDAYS.INTL if the weekend pattern is different
    • •Getting an off-by-one result because both the start and end dates are counted as workdays if they fall on a weekday, not just the days between them
    Related Functions
    WORKDAYCalculates a future or past date a number of workdays away, the reverse of counting workdays between two dates.
    WEEKDAYIdentifies which day of the week a single date falls on.
    EDATEShifts a date by whole months instead of counting individual workdays.
    Frequently Asked Questions

    Does NETWORKDAYS automatically exclude public holidays?

    No, only weekends are excluded by default. Supply a range of holiday dates as the third argument to exclude them too.

    Are the start and end dates included in the count?

    Yes, both are counted as workdays if they fall on a weekday, so the result includes both endpoints, not just the days strictly between them.

    What if my company's weekend isn't Saturday and Sunday?

    Use NETWORKDAYS.INTL instead, which lets you specify a custom weekend pattern, like Friday-Saturday.

    Need to translate a formula using NETWORKDAYS?

    Use our translator to convert your complete formula