I'm trying to summarise a member database using pivot tables in Excel 2003.
My source data includes a field for date of joining (dd/mm/yyyy). I would
like to create a pivot table showing YEAR of joining as a variable and I'm
sure it's possible to group individual dates into weeks or months or years,
however I can't find how to make this happen.