+ Reply to Thread
Results 1 to 2 of 2

Array match between dates

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    54

    Array match between dates

    Hi,
    I'm trying pull dates from a range on tab 2 that are between date referenced cells on tab 1 and display them all.

    Tab 2 has data connected table that populates date when I open the excel file.

    Tab one is the "Working" tab that I will use to reference the dates.

    Tab one would display all dates between the 2 cells on tab 1 from tab 2.

    I tried to index them but can not figure out the code.

    index(rng, between Cell1 and Cell 2, display on tab 1)
    next row repeat
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Array match between dates

    I don't see anything on Sheet1 that would qualify as being "between date referenced cells".
    It might help if you could manually type the expected results on sheet1 so that we will know what our formulas/code are expected to yield.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 5
    Last Post: 02-22-2018, 01:47 AM
  2. Array Pull With Transpose Between Two Dates? [Tricky Index/Match Formula]
    By larryg003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2017, 10:41 AM
  3. [SOLVED] Array Match and Return value upon multiple array match criteria
    By VegetaOSX in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 05:50 AM
  4. [SOLVED] Search between dates inside a MATCH array formula
    By BlueAstro in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-04-2014, 01:02 PM
  5. Array formula to check if dates returned from another array formula falls between 2 dates
    By Atul Maskara in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2014, 09:54 PM
  6. [SOLVED] Array of dates when tested shows no dates ......but there are dates
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-29-2012, 12:45 PM
  7. [SOLVED] Highlight Group of Dates if Dates Match List of other Dates
    By martinpgibson in forum Excel General
    Replies: 5
    Last Post: 10-24-2012, 08:14 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