» PivotTable report - Grouping the Date Field by Week Number
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To group by week number, add a column to the source data containing the formula WEEKNUM:1. In the source data, insert new column and enter the WEEKNUM formula into it.
2. In the second argument of the formula, set Return Type to 2 (1 = Sunday, 2 = Monday..


Book Store:
Recommended Books:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Windows XP for Dummies
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Marketing Management
- Understanding Financial Statements
No comments have been submitted.

