Filter calendaristic data

**Marfly** · 11-27-2020, 03:18 PM

Sorry for my simply question, but I am a begginer in working with Excel.

My question is how could I make a filter on a column with calendaristic dates (dd/mm/year) so the Excel to show only the years.

For example, if I have calendaristic dates from 2 different years, I want to make a filter and in that column to appear only those 2 years, not all the dates.

**alansidman** · 11-27-2020, 06:43 PM

Please read the yellow banner at the top of this page on how to attach a file.

**Marfly** · 11-28-2020, 01:45 AM

I hope a I have attached the file.
So, in the column invoicedate, I would like to appear only the 2 years: 2010 and 2011 (cumulated data), if it is possible.

**alansidman** · 11-28-2020, 05:37 AM

Place your cursor on one of the dates in your PT. Then on the Analyze Tab of the Ribbon select Group Selection. Select years and unhighlight other selections.