» PivotTable report - Grouping the Date Field by Week Number
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
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:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Microsoft Windows XP Registry Guide
- Financial Reporting and Analysis (2nd Edition)
- Getting to Yes: Negotiating Agreement Without Giving In
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
