Thread: Need a macro to filter date

Spreadsheet that is used for delivery schedule. Column A is a list of locations, Column B is a list of date, both past due and for the upcoming 12 months.

Macro Needed:- On any given day one would open the spreadsheet and hit a macro button that can filter column B to show delivery dates that are past due and delivery dates that are 3 weeks out, based on todays date according to time/date of Windows OS.

I know you can just do a manual filter, but for some reason it proves to be challenge for some of our older salespeople.
Thank you for your help.

Please attach a spreadsheet so we can help you out easily.