1 Reply Latest reply: Sep 29, 2011 7:32 AM by Sunil Chauhan RSS

    Number of weeks calculation

    Saurabh Mudgil

      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