1 Reply Latest reply on Jul 15, 2015 11:01 AM by ailsa.zheng

    Date Display and Calculation

    Prima Baines

      Good day!

       

      I am working a column that has dates and I am trying to do the following:

       

      1. Display: I have selected the "week" option of displaying the dates of the current year, but it's showing the first of the week (Monday's Date) vice the last week of the week (Sunday's Date).  How can I change the display to show what I need?

      2.  Sum of the Week :  How can I calculate the sum of the sales column based on a week's worth of calculation (MON to SUN)?

       

      Looking forward to your response.

       

      V/R,

      Prima