+ Reply to Thread
Results 1 to 6 of 6

Filter Two Columns using Date Range Criteria

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Question Filter Two Columns using Date Range Criteria

    Using the excel document attached. The "Job Start" and "Job Finish" columns are to be filtered to show dates that fall within the next 2/2-4 weeks of the selected "Period Date". So in the document, there are 6 jobs out of 10 that met the criteria of the filters.

    The goal: Is there a way to use to automate the process of filtering the "Job Start" and "Job Finish" columns using the formula: WORKDAY.INTL(TODAY(),--(WEEKDAY(TODAY())<>6),"1111011") ??? Currently, we have to go in and manually select the dates within 4 weeks of the determined "Period Date" to get the jobs meeting the criteria. Is there a better way to do this? Thank you again!!

    Clarification: I need the "Job Start" and "Job Finish" columns to be filtered to show dates within 4 weeks of the "Period Date" at the same time. The job needs to show if 1 of the 2 columns meets that criteria or both meet it.

    Let me know if I can provide additional information! Thank you!!!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2202
    Posts
    1,468

    Re: Filter Two Columns using Date Range Criteria

    i looked this over quickly, but couldn't you just filter on column F (Period) and unselect (BLANKS) from the filter.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Re: Filter Two Columns using Date Range Criteria

    Column F or "Period" is formula based on the results of Columns D & E. "Job Start" and "Job Finish" have to be filtered before "Period" can determine its value.

  4. #4
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2202
    Posts
    1,468

    Re: Filter Two Columns using Date Range Criteria

    My understanding is you want the filter to show all job starts and finishes that are within next 2 weeks. It looks like your formula in Column F narrows this down for you looking at both columns D and E. It also looks like the formula in column F returns a (BLANK) if the dates in D and E arent within the 2 weeks based on the period date in A2. So why not use your formula before filtering, and then filter out the (Blanks in Column F). Its very possible i am not fully understanding what you want.

  5. #5
    Registered User
    Join Date
    07-08-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    29

    Re: Filter Two Columns using Date Range Criteria

    dosydos,

    You understood the issue perfectly. I was the one who didn't understand your first response. Your solution is simple and effective. Thank you!
    Problem resolved.

  6. #6
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2202
    Posts
    1,468

    Re: Filter Two Columns using Date Range Criteria

    Glad it was an easy fix for ya. Thanks for the Rep

+ 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. [SOLVED] Advanced Filter Code : Criteria Range More Than 1 Row Breaks Filter
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2021, 04:30 PM
  2. Replies: 3
    Last Post: 01-18-2018, 12:20 PM
  3. Possible to use a named range as criteria for date filter?
    By VBA_Newguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2017, 11:15 AM
  4. Filter and copy non continguos columns (criteria by Date another sheet)
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 12:36 PM
  5. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  6. Replies: 10
    Last Post: 02-19-2013, 12:05 PM
  7. Filter for date range across multiple columns and multiple worksheets
    By Pugface in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2011, 05:30 AM

Tags for this Thread

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