Advanced Filtering by Date (or Macro) Help

G

Guest

I'm trying to use the advanced filter with a date as one of the filter
cateria (it will be inside a macro).

I'm trying to use the "=now()-60" format for the date, because I need
information to be filtered so that anything greater than or equal to that 2
month back date shows up. I can get it to work when I manually set the date,
but as part of a macro, I don't think it's going to work.

The only other thing I can think of is having the macro promt the user for
the date, and I've looked around, and haven't been able to find a way to
prompt a use while the macro is running. I could just be blind. Any ideas?

Thanks for the help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A function for filtering between Dates 4
Pivot table macro filter data between yesterday and today (date+time) 0
advanced filter date criteria 1
how to create macro to use cell references for data filter criteri 3
Advanced filter a dynamic date range 2
Outlook Macro to set Reminder on a Contact tomorro 9:00 4
Macro to copy value in field and insert it into filter 2
Fixing the date format in a macro or VBA 1

Top