Hi all,
I'm trying to filter 2 date columns to include only data containing dates within 3 months of today's date.
I see there is a data filter option for "next quarter" but not 100% sure if this covers the quarter from today's date?
Hi all,
I'm trying to filter 2 date columns to include only data containing dates within 3 months of today's date.
I see there is a data filter option for "next quarter" but not 100% sure if this covers the quarter from today's date?
You could add a column that tests the dates and then filter on this new column.
For example:
Data Range
A B 3 12/4/2013 FALSE 4 3/13/2014 TRUE 5 2/18/2014 TRUE 6 4/18/2014 FALSE 7 3/10/2014 TRUE 8 3/12/2014 TRUE 9 11/24/2013 FALSE 10 3/30/2014 FALSE
This formula entered in B3 and copied down:
=AND(A3>=EDATE(NOW(),-3),A3<=TODAY())
Then you would filter on column B = TRUE.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
thanks for the formula Tony, i've modified it slightly to give me the answer's i'm looking for: =IF(AND(A3<EDATE(NOW(),3),A3>TODAY()),"PASS","")
Ideally i'd not like to create new columns as there's a lot going on in the file (macro's, button's etc)
Without the additional column you'd have to do it manually.
Select the filter drop down on the date column
Select Date Filters>Between
Select Is After 3/20/2014
Select Is Before 6/20/2014
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks