Documentation/Calc Functions/NETWORKDAYS EXCEL2003

    From The Document Foundation Wiki
    Other languages:

    Function name:



    Date and Time


    Calculates the net number of work or business days between two dates. Holidays (or other non-work days) can be specified and these are excluded from the count, together with the standard weekend days of Saturday and Sunday.

    NETWORKDAYS_EXCEL2003 exists only for interoperability with legacy documents created with older versions of Microsoft Excel. In Calc, if you open an Excel 2003 (.xls) file that contains calls to the NETWORKDAYS function, those calls are converted to calls to the NETWORKDAYS_EXCEL2003 function. If you save a document from Calc in ODS (Open Document Format for Office Applications) or OOXML (Office Open XML) format, any calls to the NETWORKDAYS_EXCEL2003 function are converted to refer to the NETWORKDAYS function.

    Because of the limited applicability of this function, fuller details are intentionally omitted from this wiki.

    Note pin.svg

    For all new documents and most cases that do not require interoperability with legacy Excel spreadsheets, it is recommended that you use Calc’s two more flexible functions to calculate the net working days between two dates. These are NETWORKDAYS (compliant with ODF 1.2) and NETWORKDAYS.INTL (compatible with the Excel function of the same name).


    NETWORKDAYS_EXCEL2003(StartDate; EndDate[; Holidays])





    Additional details:




    Related LibreOffice functions:


    ODF standard:


    Related (or similar) Excel functions: