Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

NETWORKDAYS Formula

NETWORKDAYS formula is used to get the number of workdays between two dates. It excludes weekends and holidays. 

Syntax for NETWORKDAYS formula

NETWORKDAYS( start_date, end_date, [holidays] )

Parameters Details:

• start_date : The start date to use in the calculation and should be entered as a serial date, not a text date.

• end_date : The end date to use in the calculation and should be entered as a serial date, not a text date.

• holidays: Optional. It is the list of holidays to exclude from the workday’s calculation. It can be entered either as a range of cells that contain the holiday dates (i.e. E2:E5) or as a list of serial numbers that represent the holiday dates.

Return

The NETWORKDAYS function returns a numeric value.