You realize you are using the right document editor when such a simple job as Group date document does not take more time than it should. Editing documents is now an integral part of numerous working processes in various professional fields, which explains why convenience and efficiency are crucial for editing instruments. If you find yourself studying guides or searching for tips about how to Group date document, you may want to find a more user-friendly solution to save time on theoretical learning. And here is where DocHub shines. No training is needed. Just open the editor, which will guide you through its principal functions and features.
A workflow becomes smoother with DocHub. Use this instrument to complete the paperwork you need in short time and take your efficiency to another level!
in this workbook we have sales data and a pivot table that summarizes all the quantities sold were going to see how to group those sales into four week periods that match our sales periods we dont want to use standard month groupings because our company has 13 periods per year four weeks per period heres the sales data we can see that theres a date in the first column and then information about what we sold from this data weve built a pivot table and it summarizes all the sales by date instead of having a long list of dates Im going to group them and to do that Ill right-click on any one of the dates click group then you get some built-in options so it will usually have months selected when you go in you could summarize by year and months or quarters but were going to unselect those we would like four-week periods and theres no option here for weeks but we can use days there are seven days per week weve got four weeks so that will be a total of 28 days so that will be our gr