» Grouping a Date Field by a Week Number in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
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:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The One Page Business Plan: Start With a Vision, Build a Company!
- Financial Risk Manager Handbook, Second Edition
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The New Financial Order: Risk in the Twenty-First Century
- Business Plans For Dummies®
No comments have been submitted.
