Need to filter a list between two dates
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Need to filter a list between two dates

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I haved tried using custom filter but this is not working. My project is a list which contains dates when an incident happened i need to find out how many incidents occured in a week, so i need to be able to split the dates over the range in to weekly lots.Any ideas would be greatly apreciated.

    [ This Message was edited by: drag-driver on 2002-03-01 07:09 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-01 06:56, drag-driver wrote:
    I haved tried using custom filter but this is not working. My project is a list which contains dates when an incident happened i need to find out how many incidents occured in a week, so i need to be able to split the dates over the range in to weekly lots.Any ideas would be greatly apreciated.

    [ This Message was edited by: drag-driver on 2002-03-01 07:09 ]
    Care to post some data?

    If inclined to do so, activate an empty cell, type =, select 5 to 10 rows of relevant data including the labels, hit F9, copy what you see, and post it in the follow up along with expected results.

    Note. You might want to have a look at PivotTables instead of a formula-based approach.

    Aladin

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    For a data field named 'Date'...

    1. Enter a date from the week of interest into a cell D2.

    2. Enter "Date" into cells E1:F1.

    3. Enter the formula, =">="&TEXT(-WEEKDAY($D$2)+1+$D$2,"m/d/yy"), into cell E2.

    4. Enter the formula, ="<="&TEXT(7-WEEKDAY($D$2)+$D$2,"m/d/yy"), into F2.

    5. Use E1:F2 and your criteria range.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com