Filter by year

[Nightshade]

Hello,

I have a column of dates, and wish to filter them by year. I tried an auto
filter and did a custome filter of (ends in *2007) this didn't work. Any
ideas?

1/11/2007
16/3/2007
25/5/2007

 

[Kevin B]

Somewhere to the right of your date column, create a Year column and use the
following formula to extract the year from your dates, substituing cell A2
for the starting cell of your date column:

=YEAR(A2)

Copy down as far as necessary and use the year column as your filter column

 

[CLR]

One way would be to use a helper column and pull out the year with something
like =YEAR(A2), copied down.........then filter on that column.

Vaya con Dios,
Chuck, CABGx3

 

[Don Guillett]

try
Custom>greater or = 39083 AND less than 39448

 

[CLR]

Another would be to convert the date-number to a TEXT value, with this
formula copied down a helper column, then you could do your "ends with" thing

=TEXT(A2,"dd/mm/yyyy")

Vaya con Dios,
Chuck, CABgx3

 

[Ron de Bruin]

Hi Nightshade

See also this add-in
No need for a helper column
http://www.rondebruin.nl/easyfilter.htm