Explanation

The ExcelNETWORKDAYS functioncalculates the number of working days between two dates.

Note that NETWORKDAYSincludesboth the start and end dates in the calculation if they are workdays.

NETWORKDAYS can also exclude a custom list of holidays.

Excel formula: List workdays between dates

This formula returns 3, since two of the 5 days are holidays.

Custom weekends

If you need take into account custom weekends (i.e.

weekends are Saturday only, Sunday and Monday, etc.)

Excel formula: Working days left in month

Need a date?

If you need a date n workdays in the past or future, see theWORKDAYfunction.

NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.

Excel formula: Get work hours between dates

…

NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.

Excel formula: Add business days to date

Excel formula: Get work hours between dates custom schedule

Excel formula: List holidays between two dates

Excel formula: Calculate days open

Excel NETWORKDAYS function

Excel NETWORKDAYS.INTL function