https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009767#M1221709 <P>Hi! what would be the best way to calculate, for example, the third business day of each month? Using networkdays?&nbsp; Thanks in advance,</P> Mon, 28 Nov 2022 13:37:48 GMT MigueldelCampo 2022-11-28T13:37:48Z https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009767#M1221709 <P>Hi! what would be the best way to calculate, for example, the third business day of each month? Using networkdays?&nbsp; Thanks in advance,</P> Mon, 28 Nov 2022 13:37:48 GMT https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009767#M1221709 MigueldelCampo 2022-11-28T13:37:48Z https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009785#M1221710 <P>I believe you'd want to use LastWorkDate() for this (or possibly FirstWorkDate(), I always get them mixed up).</P> Mon, 28 Nov 2022 14:00:45 GMT https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009785#M1221710 Or 2022-11-28T14:00:45Z https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009786#M1221711 <P>I understand, but how do I define business days if, for example, Sunday is Christmas? (this year it is like that)</P> Mon, 28 Nov 2022 14:03:24 GMT https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009786#M1221711 MigueldelCampo 2022-11-28T14:03:24Z https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009789#M1221712 <P>You can manually list holidays, the syntax is in documentation so it should be easy to find...</P> Mon, 28 Nov 2022 14:04:30 GMT https://community.qlik.com/t5/QlikView/Best-way-to-calculate-for-example-the-third-business-day/m-p/2009789#M1221712 Or 2022-11-28T14:04:30Z