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

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 ??

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

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"GTolhurst" wrote in message ...
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 ??