How to use NETWORKDAYS formula in Excel with Video and Example Download

How to use NETWORKDAYS formula in Excel with Example Download

If you want to find number of working days between two date, date_1 and date_2 in Microsoft Excel, NETWORKDAYS could help with option with or without holidays.

NETWORKDAYS formula in Excel

NETWORKDAYS returns number of working days without count from list of holidays if specify.
FORMULA:

NETWORKDAYS(Start_date, End_date,[holiday])

◾ start_date: Required, start date should smaller then end date.
◾ end_date: Required, end date is used to find number of working day from start date.
◾ holidays: Optional, list of holidays if have.
Watch How to use NETWORKDAYS formula in Excel speak Khmer

DOWNLOAD EXAMPLE EXCEL FILE