Results 1 to 13 of 13

How do I extract data between dates?

Threaded View

Budhdr How do I extract data between... 01-25-2018, 02:49 PM
63falcondude Re: How do I extract data... 01-25-2018, 02:55 PM
Budhdr Re: How do I extract data... 01-25-2018, 03:00 PM
63falcondude Re: How do I extract data... 01-25-2018, 03:03 PM
Budhdr Re: How do I extract data... 01-25-2018, 03:18 PM
Budhdr Re: How do I extract data... 01-25-2018, 03:21 PM
Budhdr Re: How do I extract data... 01-25-2018, 03:07 PM
63falcondude Re: How do I extract data... 01-25-2018, 03:19 PM
63falcondude Re: How do I extract data... 01-25-2018, 03:24 PM
Budhdr Re: How do I extract data... 01-25-2018, 03:30 PM
63falcondude Re: How do I extract data... 01-25-2018, 03:38 PM
Budhdr Re: How do I extract data... 01-25-2018, 07:29 PM
63falcondude Re: How do I extract data... 01-26-2018, 09:12 AM
  1. #1
    Registered User
    Join Date
    01-11-2018
    Location
    New York, New York
    MS-Off Ver
    2010,2013,2016, 2019, 365
    Posts
    24

    How do I extract data between dates?

    Hello I'm trying to extract data based on the dates. For example, I want the data from my Master List to come to my October 2017 sheet only if they were in the month of October. I tried messing around with the formulas and this is what I tried and I keep getting #value. It's long but I felt like I got everything down.
    I want something that could be automatic because this is a datasheet that will be constantly updated.

    =IF(ROWS(A$3:A3)>$H$1,"",INDEX('Master List'!$A$4:$A$1000,SMALL(IF(('Master List'!$A$4:$A$1000>=$C$1)*('Master List'!$A$4:$A$1000<=$E$1),ROW('Master List'!$A$4:$A$1000)-ROW('Master List'!$A$4:$A$1000)+1,ROWS(A$3:A3))))

    I will attached the file I'm working with.
    Attached Files Attached Files
    Last edited by Budhdr; 01-25-2018 at 03:19 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract data from between two dates
    By ppidgursky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2017, 11:44 AM
  2. Extract data between two dates
    By Tarentum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2017, 05:48 PM
  3. [SOLVED] Extract Data Between 2 Dates
    By omagoodness in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2016, 12:48 AM
  4. Extract data between two dates to listbox
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2015, 07:07 PM
  5. Extract data between two dates
    By Ogi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-24-2014, 07:19 AM
  6. Extract data between two dates
    By grey_hair in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2011, 10:25 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