Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Pivot table displays only month of full date - can't display year. Detlef_Lewin Best and simplest solution ever. I have wrestled with this for a while and wondered why Microsoft would change the previous default format displays. Seems so counter intuitive.