topic Re: Add week days only to a date in QlikView https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420040#M1159669 <HTML><HEAD></HEAD><BODY><P>Try LastWorkDate() function:</P><P></P><P>lastworkdate(today()+1, 10)</P><P></P><P>will add 10 working days to today (not counting today itself).</P></BODY></HTML> Fri, 08 Feb 2013 16:37:09 GMT swuehl 2013-02-08T16:37:09Z Add week days only to a date https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420039#M1159668 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I add only week days to a date. I am trying to set a due date but I only want business days. For example, if I do date(current_date + 10) as due_date gives me calendar days. I want the due date to show 10 week days from the current date.</P><P></P><P>Thanks!!</P></BODY></HTML> Fri, 08 Feb 2013 16:19:45 GMT https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420039#M1159668 regowins 2013-02-08T16:19:45Z Re: Add week days only to a date https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420040#M1159669 <HTML><HEAD></HEAD><BODY><P>Try LastWorkDate() function:</P><P></P><P>lastworkdate(today()+1, 10)</P><P></P><P>will add 10 working days to today (not counting today itself).</P></BODY></HTML> Fri, 08 Feb 2013 16:37:09 GMT https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420040#M1159669 swuehl 2013-02-08T16:37:09Z Re: Add week days only to a date https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420041#M1159670 <HTML><HEAD></HEAD><BODY><P>Great, Thanks!</P></BODY></HTML> Fri, 08 Feb 2013 16:44:40 GMT https://community.qlik.com/t5/QlikView/Add-week-days-only-to-a-date/m-p/420041#M1159670 regowins 2013-02-08T16:44:40Z