https://community.qlik.com/t5/QlikView/Get-the-date-5-networkdays-from-selected-date/m-p/1879485#M1216792 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134249">@D19PAL</a>&nbsp; you can use script or other</P> <P>or you can for example use in UI:</P> <LI-CODE lang="python">=pick(Match(networkdays(DateRef,Date(DateRef+5)),5,4,3,1), Date(DateRef+5), Date(DateRef+6), Date(DateRef+7), Date(DateRef+8) )</LI-CODE> <P>&nbsp;</P> <P>output:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1641904132252.png"><img src="https://community.qlik.com/skins/images/02770EC0BC01C66F20EC4EACC3851929/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_0-1641904132252.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1641904153595.png"><img src="https://community.qlik.com/skins/images/02770EC0BC01C66F20EC4EACC3851929/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_1-1641904153595.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_2-1641904171076.png"><img src="https://community.qlik.com/skins/images/02770EC0BC01C66F20EC4EACC3851929/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_2-1641904171076.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 11 Jan 2022 12:29:38 GMT Taoufiq_Zarra 2022-01-11T12:29:38Z https://community.qlik.com/t5/QlikView/Get-the-date-5-networkdays-from-selected-date/m-p/1879149#M1216785 <P>Hi,</P> <P>I got a field with dates&nbsp; for each date selected, u want to know what will be the date after 5 networkdays.&nbsp;</P> <P>&nbsp;</P> <P>Thanks</P> <P>&nbsp;</P> Mon, 10 Jan 2022 18:52:54 GMT https://community.qlik.com/t5/QlikView/Get-the-date-5-networkdays-from-selected-date/m-p/1879149#M1216785 D19PAL 2022-01-10T18:52:54Z https://community.qlik.com/t5/QlikView/Get-the-date-5-networkdays-from-selected-date/m-p/1879485#M1216792 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134249">@D19PAL</a>&nbsp; you can use script or other</P> <P>or you can for example use in UI:</P> <LI-CODE lang="python">=pick(Match(networkdays(DateRef,Date(DateRef+5)),5,4,3,1), Date(DateRef+5), Date(DateRef+6), Date(DateRef+7), Date(DateRef+8) )</LI-CODE> <P>&nbsp;</P> <P>output:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1641904132252.png"><img src="https://community.qlik.com/skins/images/02770EC0BC01C66F20EC4EACC3851929/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_0-1641904132252.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_1-1641904153595.png"><img src="https://community.qlik.com/skins/images/02770EC0BC01C66F20EC4EACC3851929/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_1-1641904153595.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_2-1641904171076.png"><img src="https://community.qlik.com/skins/images/02770EC0BC01C66F20EC4EACC3851929/responsive_peak/images/image_not_found.png" alt="Taoufiq_Zarra_2-1641904171076.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 11 Jan 2022 12:29:38 GMT https://community.qlik.com/t5/QlikView/Get-the-date-5-networkdays-from-selected-date/m-p/1879485#M1216792 Taoufiq_Zarra 2022-01-11T12:29:38Z