+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

    Filter data by date (within 3 months of todays 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?

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Filter data by date (within 3 months of todays 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.

  3. #3
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    450

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

    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)

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

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

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Custom date filter for next twelve months from a specific date
    By andymcnichol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 07:24 PM
  2. How to Filter Todays date and Before
    By Armstong in forum Excel General
    Replies: 3
    Last Post: 10-11-2012, 08:06 AM
  3. days, months and years between todays date and a series of dates
    By jonathanpalmer in forum Excel General
    Replies: 4
    Last Post: 09-22-2010, 03:04 AM
  4. Using VB to find a range based on todays date and todays date +30
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 09:31 AM
  5. Replies: 3
    Last Post: 05-28-2008, 01:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1