» 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:
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Special Edition Using Microsoft Word 2002
- Mortgages For Dummies®
- The Fall of Advertising and the Rise of PR
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Accounting and Financial Fundamentals for Nonfinancial Executives
No comments have been submitted.
