topic Number of weeks calculation in QlikView https://community.qlik.com/t5/QlikView/Number-of-weeks-calculation/m-p/299820#M497371 <HTML><HEAD></HEAD><BODY><P>Interval(Date1-date2,'DD')/7</P><P></P><P></P><P>hope this helps you</P></BODY></HTML> Thu, 29 Sep 2011 11:32:31 GMT SunilChauhan 2011-09-29T11:32:31Z Number of weeks calculation https://community.qlik.com/t5/QlikView/Number-of-weeks-calculation/m-p/299819#M497370 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Is there is any way to calculate the number of weeks between 2 date intervals excluding saturday and sunday.</P><P></P><P>For Ex: I want to calculate the number of weeks between assignment start date(1/4/2011) and assignment end date(31/8/2011). So is there is any easy way to do this. </P><P></P><P>I am attaching the XL file of my current scenario to you please have a look and let me know for any solution asap. Here asssdate is my start date and assedate is my end date.</P><P></P><P></P><P>Regards,</P><P>Saurabh Mudgil</P></BODY></HTML> Thu, 29 Sep 2011 10:58:12 GMT https://community.qlik.com/t5/QlikView/Number-of-weeks-calculation/m-p/299819#M497370 2011-09-29T10:58:12Z Number of weeks calculation https://community.qlik.com/t5/QlikView/Number-of-weeks-calculation/m-p/299820#M497371 <HTML><HEAD></HEAD><BODY><P>Interval(Date1-date2,'DD')/7</P><P></P><P></P><P>hope this helps you</P></BODY></HTML> Thu, 29 Sep 2011 11:32:31 GMT https://community.qlik.com/t5/QlikView/Number-of-weeks-calculation/m-p/299820#M497371 SunilChauhan 2011-09-29T11:32:31Z