https://community.qlik.com/t5/QlikView/Business-Days-help/m-p/1559972#M744047 Hi Mahitham,<BR /><BR />You can use lastworkdate function:<BR />lastworkdate([Actual Date], 35) AS NextDate<BR /><BR />Thanks,<BR />Vitalii Fri, 22 Mar 2019 09:21:39 GMT vitaliichupryna 2019-03-22T09:21:39Z https://community.qlik.com/t5/QlikView/Business-Days-help/m-p/1559908#M744046 <P>Hi,</P><P>I have the Actual Date field like below in the attached QVD.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Actual Date 2 .png" style="width: 386px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8610i822F31C0B6924893/image-size/large?v=v2&amp;px=999" role="button" title="Actual Date 2 .png" alt="Actual Date 2 .png" /></span></P><P>Could you please help me to add 35 business days.</P><P>I have null values also in Actual Date for those need to skip business days adding.</P><P><STRONG>Requirement:</STRONG></P><P>Now from this [Actual Date] I need to derive a New field called [Estimate Date] like below i.e.,</P><P><EM><STRONG>Value of <SPAN>[Actual Date] </SPAN>field + 35 business days</STRONG></EM></P><P><EM><STRONG>A “business day” is defined as any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year.</STRONG></EM></P><P>Please help me on this.</P><P>Thanks in advance</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Business-Days-help/m-p/1559908#M744046 mahitham 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Business-Days-help/m-p/1559972#M744047 Hi Mahitham,<BR /><BR />You can use lastworkdate function:<BR />lastworkdate([Actual Date], 35) AS NextDate<BR /><BR />Thanks,<BR />Vitalii Fri, 22 Mar 2019 09:21:39 GMT https://community.qlik.com/t5/QlikView/Business-Days-help/m-p/1559972#M744047 vitaliichupryna 2019-03-22T09:21:39Z