filter date excel2000

i have a column with dates
one of the date can be the "Nwo" date
i want to build a macro that the user can filtr the period
that is grater from "Nwo"
and smaller from "Nwo+60 days"
(only 60 days from "Nwo" date)

thank you
rozent

You can use EasyFilter if you want
http://www.rondebruin.nl/easyfilter.htm

Or add a helper column with a formula that display Yes if you reach your criteria


--
Regards Ron de Bruin
http://www.rondebruin.nl



"?????" <@discussions.microsoft.com> wrote in message news:[email protected]...
>i have a column with dates
> one of the date can be the "Nwo" date
> i want to build a macro that the user can filtr the period
> that is grater from "Nwo"
> and smaller from "Nwo+60 days"
> (only 60 days from "Nwo" date)
>
> thank you
> rozent

Sub Macro1()
Selection.AutoFilter _
Field:=1, _
Criteria1:=">" & CLng(Date), _
Operator:=xlAnd, _
Criteria2:="<" & CLng(Date) + 60
End Sub

Shalom
--
AP


"?????" <@discussions.microsoft.com> a écrit dans le message de news:
[email protected]...
>i have a column with dates
> one of the date can be the "Nwo" date
> i want to build a macro that the user can filtr the period
> that is grater from "Nwo"
> and smaller from "Nwo+60 days"
> (only 60 days from "Nwo" date)
>
> thank you
> rozent

Oops

You say macro
Ron on Sunday morning and not awake

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" <[email protected]> wrote in message news:%[email protected]...
> You can use EasyFilter if you want
> http://www.rondebruin.nl/easyfilter.htm
>
> Or add a helper column with a formula that display Yes if you reach your criteria
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "?????" <@discussions.microsoft.com> wrote in message news:[email protected]...
>>i have a column with dates
>> one of the date can be the "Nwo" date
>> i want to build a macro that the user can filtr the period
>> that is grater from "Nwo"
>> and smaller from "Nwo+60 days"
>> (only 60 days from "Nwo" date)
>>
>> thank you
>> rozent
>
>