<b>Pivot Tip 18</b> - Date problem: 'Cannot group that selection'

ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database.

One great feature of pivot tables is their ability to group dates into monthly or weekly totals. But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work.

Continued...