Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion
Champion

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

hope this helps you

Sunil Chauhan