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:




      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