I need to group the following by weeks if possible:
January 1, 2017
January 2, 2017
January 3, 2017
January 4, 2017
January 5, 2017
January 6, 2017
January 7, 2017
etc.
In weeks hopefully to read in a slicer week of 1-1-17 to 1-7-17, etc. How can you group these and get something like that in a slicer option? Also I would like to add functionality to have a trend line by week of the data.
I can figure out the trend line but the grouping data by week has me stuck.