How to remove weekend and holidays from your calculation

    Hi All,

     

    A very important function to use to get the number of days and remove the weekends and holidays.

     

    Syntax:

     

    networkdays (start_date, end_date [, holiday])

     

     

    Example :

    networkdays ('19/12/2013', '07/01/2014', '25/12/2013', '26/12/2013')

     

    Returns 12. This example takes the holiday 25/12/2013 to 26/12/2013 into account.

     

     

    Reference : https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/networkdays.htm