» Adding Subtotals to a Date Field
CATEGORY - Excel Subtotals
VERSION - All Microsoft Excel Versions
1. Copy the Date column and insert it twice.
2. Change the titles for the two new columns to Month and Year.
3. Select the Month column, and press Ctrl+1.
4. Select the Number tab, select Custom, and in the Type box, type MMMM.
5. Repeat steps 3 and 4 for the Year column, and in the Type box, type YYYY.
6. Sort the List by the Year column.
7. Add Subtotals to the List.

Book Store:
Recommended Books:
- Finance and Accounting for Nonfinancial Managers
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Special Edition Using Microsoft Outlook 2002
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Office XP Introductory Concepts and Techniques
- East of Eden (Oprah's Book Club)
No comments have been submitted.

