Autofilter by month & year when I have a column full of dates ??

[GTolhurst]

I have a c0lumn full of various dates (24/03/2007) over the last 5 years, I
need to be able to autofilter by month and year ??

I thought I could use a group function but it isnt working ??

Any ideas please ??

 

[Ron de Bruin]

Hi GTolhurst

You can use EasyFilter to do this
http://www.rondebruin.nl/easyfilter.htm

Or add a helper column in your data that test the month and year