topic Re: Extract Day in QlikView https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519299#M1135028 <HTML><HEAD></HEAD><BODY><P>Well, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Networkdays</SPAN> calculate how many workdays you have between 2 dates.</P><P>If you want 5th workday after a day, you should use</P><P>=LastWorkDate(Today(),5)</P></BODY></HTML> Thu, 24 Oct 2013 13:09:01 GMT Clever_Anjos 2013-10-24T13:09:01Z Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519296#M1135025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have to extract 5 day from formula Networkdays(Monthstart(Today()),Monthend(Today())).</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Regards,</P><P>Piyush jain</P></BODY></HTML> Thu, 24 Oct 2013 12:27:56 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519296#M1135025 2013-10-24T12:27:56Z Re: Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519297#M1135026 <HTML><HEAD></HEAD><BODY><P>Maybe I´m missing something, but</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Networkdays(Monthstart(Today()),Monthend(Today())) - 5 don´t do what you want?</SPAN></P></BODY></HTML> Thu, 24 Oct 2013 12:29:42 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519297#M1135026 Clever_Anjos 2013-10-24T12:29:42Z Re: Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519298#M1135027 <HTML><HEAD></HEAD><BODY><P>Hi Clever,</P><P>I just want date of 5th day extracted from above formula.</P><P></P><P></P><P></P><P>Regards</P><P>Piyush Jain</P></BODY></HTML> Thu, 24 Oct 2013 13:03:58 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519298#M1135027 2013-10-24T13:03:58Z Re: Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519299#M1135028 <HTML><HEAD></HEAD><BODY><P>Well, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Networkdays</SPAN> calculate how many workdays you have between 2 dates.</P><P>If you want 5th workday after a day, you should use</P><P>=LastWorkDate(Today(),5)</P></BODY></HTML> Thu, 24 Oct 2013 13:09:01 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519299#M1135028 Clever_Anjos 2013-10-24T13:09:01Z Re: Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519300#M1135029 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>But it will give without excluding saturday sunaday and holiday.</P><P></P><P></P><P>regards,</P><P>Piyush jain</P></BODY></HTML> Thu, 24 Oct 2013 13:28:26 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519300#M1135029 2013-10-24T13:28:26Z Re: Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519301#M1135030 <HTML><HEAD></HEAD><BODY><P>Today() + <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Networkdays(Monthstart(Today()),Monthend(Today()))</SPAN></P><P></P><P>That work?</P></BODY></HTML> Thu, 24 Oct 2013 13:34:15 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519301#M1135030 Jason_Michaelides 2013-10-24T13:34:15Z Re: Extract Day https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519302#M1135031 <HTML><HEAD></HEAD><BODY><P>Lastworkdate() excludes Sat/Sun days, if you have holiday list you can include those as well as third parameter:</P></BODY></HTML> Thu, 24 Oct 2013 13:34:45 GMT https://community.qlik.com/t5/QlikView/Extract-Day/m-p/519302#M1135031 tresB 2013-10-24T13:34:45Z