Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Interval(Date1-date2,'DD')/7
hope this helps you