» Grouping a Date Field by a Week Number in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
To Group a date field by a week number:1. In the source data, insert a new column and insert the WEEKNUM function into it.
2. In the second argument of the Function Arguments dialog box, set Return_type to 2 (1 = Sunday, 2 = Monday).
3. Refresh the PivotTable, and drag the Week Number new filed into Values area.
Book Store:
Recommended Books:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Fish! A Remarkable Way to Boost Morale and Improve Results
- How to Pay Zero Taxes (Annual)
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Business Analysis with Microsoft Excel (2nd Edition)
No comments have been submitted.
