vba filter dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F less than
or equal to todays date, and greater than or equal to todays date minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..
 
Turn on the macro recorder and perform the action manually. Use a custom
criteria and pick two dates (doesn't really make any difference which two).


Turn off the macro recorder

Now adjust the recorded code to apply the criteria you want.
 
Hi Tom how are you doing?
Thanks for all the help in the past..
I'm just using =today() in the far right coulmn and beside that a coulmn
with =P2-F2 format the coulmn for numbers and filter less than or equal to
7... Works good enough...
Have a good weekend...
DJ
 

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

Pivot table macro filter data between yesterday and today (date+time) 0
Using Query to return data from SQL database 3
advanced filter date criteria 1
loop VBA request 1
Calculate data for previous 7 days 3
convert spreadsheet formula into VBA formula 1
loop VBA request 1
Using datedif to format cell color 3

Back
Top