Pivot Tip #31: Use a VLOOKUP table to add 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.
A frequent problem with dates is that date information you need to create your pivot table simply isn't stored in the accounts package at all. For example, all accounts packages record the Calendar month and year, but some don't record the Financial period and year.