Solved

# Custom Filter and within 2 weeks

Posted on 2014-09-25
133 Views
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.

0
Question by:pdvsa

LVL 6

Assisted Solution

johnb25 earned 250 total points
ID: 40344955
Hi,

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

LVL 27

Accepted Solution

Glenn Ray earned 250 total points
ID: 40345140
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

Author Closing Comment

ID: 40369467
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

## Featured Post

### Suggested Solutions

Problem to open Excel file 15 45
Excel filter by strike though 8 26
MIN, using ARRAY 4 17
EXCEL formula help required 3 16
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.