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

filter date excel2000
 

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



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

filter date excel2000
 

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

Shalom
--
AP


"?????" a écrit dans le message de news:
...
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

filter date excel2000
 

Oops

You say macro
Ron on Sunday morning and not awake

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



"Ron de Bruin" wrote in message ...
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



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