Filter by year
 

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

Filter by year
 

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

--
Kevin Backmann


"Nightshade" wrote:

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

Filter by year
 

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



"Nightshade" wrote:

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

Filter by year
 

try
Customgreater or = 39083 AND less than 39448

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Filter by year
 

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



"CLR" wrote:

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



"Nightshade" wrote:

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

Filter by year
 

Hi Nightshade

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


--

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


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