• Breaking News

    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



    NETWORKDAYS

    NETWORKDAYS


    Download example file CLICK

    No comments

    View My Stats