Calculate the number of working days between two dates - NetworkDays function in Excel

The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.

For a custom weekend schedule, NETWORKDAYS.INTL function can be used. NETWORKDAYS.INTL excludes Saturday and Sunday by default but provides a way to specify which days of the week are considered weekends. The function can optionally exclude a list of holidays supplied as dates.

Download my Free eBook containing 51 Ready to use Macros for MS Excel


Subscribe to the channel for more


#NETWORKDAYS #CalculateWorkingDays

Excel VBA,VBA Excel,Excel Macro,MS Excel,Microsoft Excel,calculate number of working days in excel,calculate number of working days in a month,calculate number of working days in excel between two dates,networkdays function in excel,networkdays.intl function in excel,Networkdays,networkdays.intl,xl n cad,xlncad,excel tips,advanced excel tricks,excel 2016,