Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Number of weeks calculation

Hi All,

Is there is any way to calculate the number of weeks between 2 date intervals excluding saturday and sunday.

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.

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.

Regards,

Saurabh Mudgil

1 Reply
Highlighted
SunilChauhan
Esteemed Contributor

Number of weeks calculation

Interval(Date1-date2,'DD')/7

hope this helps you