8 Replies Latest reply: Apr 2, 2015 7:02 AM by AVIRAL NAG RSS

    Week Analysis...............!!

    AVIRAL NAG

      Hi All

       

      1.  I want Week categorization for every Month as Week 1, Week 2,...............

      2.  Week should be from Monday to Sunday.

      3.  The week should start only from 1st Monday coming in every Month.

       

       

      Look at my Requirement below:

       

      December 2014:
      01-07  -  Week 1
      08-14  -  Week 2
      15-21  -  Week 3
      22-28  -  Week 4
      29-04  -  Week 5

      January 2015:
      05-11  -  Week 1
      12-18  -  Week 2
      19-25  -  Week 3
      26-01  -  Week 4


      February 2015:
      02-08  -  Week 1
      09-15  -  Week 2
      16-22  -  Week 3
      23-01  -  Week 4

      March 2015:
      02-08  -  Week 1
      09-15  -  Week 2
      16-22  -  Week 3
      23-29  -  Week 4
      30-05  -  Week 5


      April 2015:
      06-12  -  Week 1
      13-19  -  Week 2
      20-26  -  Week 3
      27-03  -  Week 4

       

       

       

       

      Regards

      Av7eN