selecting date range / data range autofilter

Is it possible to select rows based on a date range (say from
01-01-2005 to 31-12-2005) from column B:

A B C
id date value
1 01-01-2005 1
2 06-01-2005 1
3 08-02-2005 1
4 16-02-2005 1
5 03-03-2005 1
6 01-01-2004 1
7 06-05-2006 1
8 05-05-2005 1
9 06-06-2005 1
10 09-0 1
sum 10

Morten

Yes.............after clicking the AutoFilter arrow on your column of
choice, choose "Custom" and in the pop-up select the "greater than" and
"less than" options to give you your range of dates............

Vaya con Dios,
Chuck, CABGx3

"hansiman" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to select rows based on a date range (say from
> 01-01-2005 to 31-12-2005) from column B:
>
> A B C
> id date value
> 1 01-01-2005 1
> 2 06-01-2005 1
> 3 08-02-2005 1
> 4 16-02-2005 1
> 5 03-03-2005 1
> 6 01-01-2004 1
> 7 06-05-2006 1
> 8 05-05-2005 1
> 9 06-06-2005 1
> 10 09-0 1
> sum 10
>
> Morten
>