Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
hope this helps you