1 Reply Latest reply on Jun 27, 2018 9:15 AM by Jim Dehner

    2018 starts on December 30th.. data by weeks

    Harriet Hitchman

      Hello!

       

      I'm trying to sort my data into weeks, in my company the week starts on a Saturday and ends on a Friday, when switching over from 2017 to 2018, the first week of 2018 for us starts on 30/12/2017 and ends 05/01/2018. I have added my data source and in the sheet view, right clicked the data source, opened date properties and assigned my week to start on a Saturday. However, the first week of the year excludes the last two days of December 2017, when I include 2017 into my data source, those dates are assigned to week 53.

       

      Is there a way I'm missing that will allow me to include the last two days of the year in 2018?

       

      Thanks,