Filter data by date (within 3 months of todays date)

**Gti182** · 03-20-2014, 08:41 AM

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?

**Tony Valko** · 03-20-2014, 09:34 AM

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.

**Gti182** · 03-20-2014, 11:26 AM

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)

**Tony Valko** · 03-20-2014, 01:42 PM

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