Pivot Tip #30: Use =MONTH and =YEAR functions to summarise dates. By David Carter

David Carter’s series of Five Minute Tips aims to develop your skill at using Excel pivot tables. If you want to test the tip for yourself, David takes you through a worked example on the pivot practice database.

If you want to summarise transactions by month, Group is the obvious way to do it.

But if just one record out of thousands contains a faulty date or blank cell, then Group doesn’t work and gives the “Cannot Group this selection” message.

Personally, I don’t use Group any more.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.