+ Reply to Thread
Results 1 to 8 of 8

Filter for workdays returns nothing.

  1. #1
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Filter for workdays returns nothing.

    I am looking to find a way to filter a list for the next twenty business days
    Last edited by frank35; 07-09-2014 at 02:13 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Filter for workdays returns nothing.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Filter for workdays returns nothing.

    Let me ask this way, how do you filter a range for the next twenty business days? alternative way to filter?
    Last edited by frank35; 07-09-2014 at 03:34 PM.

  4. #4
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Filter for workdays returns nothing.

    You're using an AND operator in there. I believe you want OR.
    There's never going to be a date that simultaneously -1 and +6 from today!
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  5. #5
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Filter for workdays returns nothing.

    how to fix it ?

  6. #6
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Filter for workdays returns nothing.

    i am looking for a range, all days within the next 20 days does that work?
    Last edited by frank35; 07-09-2014 at 03:35 PM.

  7. #7
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Filter for workdays returns nothing.

    anything? is it not possible to select a range like this? any sample would be cool!

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Filter for workdays returns nothing.

    Quote Originally Posted by frank35 View Post
    anything? is it not possible to select a range like this? any sample would be cool!
    ....and a response to post #2 would be cool too.

+ 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. Advanced Filter : One Criteria Cell Breaks the Filter - Returns Only Headers
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 10:06 AM
  2. Advanced Filter Macro (only returns column headings)
    By Mufasta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2011, 11:56 AM
  3. adv. filter unique records only returns duplicates
    By stratplayer in forum Excel General
    Replies: 4
    Last Post: 01-31-2011, 05:52 PM
  4. When i try to filter information, excel returns a blank page?
    By AJoudrie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2006, 04:40 PM
  5. [SOLVED] Auto Filter returns no results
    By terrapinie in forum Excel General
    Replies: 2
    Last Post: 01-07-2006, 04:10 AM

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