How to get Net Working Days count in Excel

Hi Friends,

How to use NETWORKDAYS formula in excel

NETWORKDAYS(start_date, end_date, [holidays])

Start_date    Required. A date that represents the start date.

End_date    Required. A date that represents the end date.

Holidays    Optional. An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates.

Example 1

NETWORKDAYS without Holiday(s). 

From some previous date to today

Here I have put a date 01st Aug in Cell A2 and checking the no of days from 01st August to today. ( My post date is on 08th Sep, hence it is taking 27 days )

The Formula is ( Cell B2)  =NETWORKDAYS(A2,TODAY())

Date	No of Days
8/1/2020	27

Example 2

NETWORKDAYS with Holiday(s). 

From some previous date to today and in between some holidays are also there

Here I have put a date 01st Aug in Cell A2 and checking the no of days from 01st August to today. ( My post date is on 08th Sep, hence it is taking 25 days). Assuming there are 2 holidays in August that is on 3rd & 12th Aug

I have made a list of holidays in column E

The Formula is ( Cell B2) = NETWORKDAYS(A2,TODAY(),$E$3:$E$4)

Make sure you freeze the Holiday Cell range in the formula by putting dollar $ sign, else it will take wrong calculation if you drag the formula in column B 

Date	No of Days
8/1/2020	25			Holiday
8/2/2020	25			8/3/2020
8/3/2020	25			8/12/2020
8/4/2020	25
8/5/2020	24
8/6/2020	23
8/7/2020	22
8/8/2020	21
8/9/2020	21
8/10/2020	21
8/11/2020	20

In Example 1 the no of days are coming as 27 for 01st Aug but in example 2 the no of days are coming 25 that means it is excluding 2-holiday dates

Download example file CLICK