This content has been marked as final. Show 2 replies
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