can I use autofilter with an equation
 

I am trying to filter dates such that I want all rows where the date is less
than 30 days forward. In other words I'm looking to see only the rows which
are within the next 30 days.

In MS-Project VBA I can insert into the Finish Date field autofilter the
fo0rmula Value:=(Now() - 28) and get my results

Thanks

can I use autofilter with an equation
 

Hi
use the advanced filter for this

--
Regards
Frank Kabel
Frankfurt, Germany

"ds" schrieb im Newsbeitrag
...
I am trying to filter dates such that I want all rows where the date
is less
than 30 days forward. In other words I'm looking to see only the rows
which
are within the next 30 days.

In MS-Project VBA I can insert into the Finish Date field autofilter
the
fo0rmula Value:=(Now() - 28) and get my results

Thanks

can I use autofilter with an equation
 

Frank, how do I Enter the constraints such as all dates between 1/1/2004 and
5/1/2004?


"Frank Kabel" wrote in message
...
Hi
use the advanced filter for this

--
Regards
Frank Kabel
Frankfurt, Germany

"ds" schrieb im Newsbeitrag
...
I am trying to filter dates such that I want all rows where the date
is less
than 30 days forward. In other words I'm looking to see only the rows
which
are within the next 30 days.

In MS-Project VBA I can insert into the Finish Date field autofilter
the
fo0rmula Value:=(Now() - 28) and get my results

Thanks

can I use autofilter with an equation
 

You can use a Custom AutoFilter. For example:

ActiveSheet.Range("A1").AutoFilter Field:=1, _
Criteria1:="=" & CLng(Date), Operator:=xlAnd, _
Criteria2:="<=" & CLng(Date + 30)


ds wrote:
I am trying to filter dates such that I want all rows where the date is less
than 30 days forward. In other words I'm looking to see only the rows which
are within the next 30 days.

In MS-Project VBA I can insert into the Finish Date field autofilter the
fo0rmula Value:=(Now() - 28) and get my results

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html