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.
Peace of mind is found in some of the strangest places.
Can you add a helper column?
This used the built in WeekNum(), but you could make a more elaborate one that takes a date and returns a Begin-End: "9/10/17 - 9/16/17"
Capture.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
You can group the date field by 7 day intervals, which should do what you want.
Be as you wish to seem
Much better answer than mineOriginally Posted by Aflatoon
I forgot about that; I'm not sure when that feature was added, or if it's always been there, but is exactly what the OP wanted (probably)
Capture.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thanks you both. Solved.
Peace of mind is found in some of the strangest places.
Posting Permissions
Reply With Quote
