2 Replies Latest reply: Sep 26, 2014 1:40 AM by Sushil Kumar RSS

    Getting the maximum date per week

      Hi All,

       

      I have here a table in which I need to determine what is the maximum date per week.

      Please see below:

       

      Date14/9/201415/9/201416/9/201417/9/201418/9/201419/9/201420/9/201421/9/2014
      WeekNameSunMonTueWedThuFriSatSun
      A
      B
      C

       

      For example, the starting week is = Mon, End week = Sun. So I only need to sumup all the values from Mon-Sun then put it in the cell 21/9/2014 (Sun). All the other fields are 0 and only the Sunday will have the value. Unless the last day of the week is not sunday; for example the last day of the week is 18/9/2014 then it will accumulate Mon-Thursday only and the data should be inside the cell Thu.

       

      I hope you get the idea. Feel free to ask questions. Thanks - Lyn