On 6 Feb, 10:02, "Ron de Bruin" wrote:
Hi Peter

You can insert a helper column with the worksheet function Year or Month
Or install EasyFilterhttp://www.rondebruin.nl/easyfilter.htm

Or use advancedfilter, you only have to have one cell with the formula and use that cell in your criteria.

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Peter" wrote in ooglegroups.com...
I have a column of dates that I am trying to filter on just the month
and year.

Date
22/05/1981
16/03/1981
26/01/2006
01/05/1986

Is it possible to filter on only the last 4 digits of a cell?

Thanks,

Peter- Hide quoted text -

- Show quoted text -

Thank you but I am actually trying to tell the macro to look at the
last 7 digits of a cell and filter it by that. Is this possible?