Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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
SunilChauhan
Esteemed Contributor

Number of weeks calculation

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

hope this helps you