Custom Filter and within 2 weeks

Hello,

I need to filter dates in a column for anything between Today() and <Today()+15 days.

The options in regards to weeks are only the current week and next week but I need both.

Thank you.  I am using 2013.

Not sure if I would use the Custom AutoFilter.  I am interested in saving the filter so I can use it at will.

Untitled.jpg
pdvsaProject financeAsked:
Who is Participating?
 
Glenn RayExcel VBA DeveloperCommented:
John, your formula - although surprising because I'd never used Advanced formulas that way - is filtering OUT the values between today and today+15.

Reversing the two formulas:
AM2: =A2<=TODAY()
AN3: =A2>=TODAY()+15

filters the range to show just the dates in the 15-day period.

Another interesting - and cool feature - is that the data and filter ranges are preserved.

-Glenn
0
 
johnb25Commented:
Hi,

You can use Advanced Filter.
If your dates start in cell A2, enter these formulae as the Criteria e.g. in cell AM2  =A2>=TODAY(); in cell AN3 =A2<TODAY()+15. Your Criteria range in the Advanced Filter box will be $AM$1:$AN$3.

John
0
 
pdvsaProject financeAuthor Commented:
that was pretty complicated.  Sorry for my tardy reply.  I must have deleted the automatic email I received telling me there was a response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.