Results 1 to 4 of 4

Search date + X days prior with Array Formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2020
    Location
    Lynnwood, WA
    MS-Off Ver
    2016
    Posts
    27

    Search date + X days prior with Array Formula

    Hello!

    I have an array function that I use for looking up names automatically within a range and only displaying the names that follow that criteria (shown below)

    {=IFERROR(INDEX(Table1[IDENTIFIER],MATCH(0,IF("funded"=Table1[STATUS],COUNTIF(F$1:F1,Table1[IDENTIFIER]),"sup"),0)),"")}
    If anything in the status column matched with "funded" it would auto pull all the names and show them in a list. I have the array going from a1 to d250, so if only 25 names are available, it'll only show the 25 and the rest of the cells are blank.

    What I am trying to accomplish is instead of the status column showing "funded", it's searching for dates within a certain range of today, and then displaying the names associated with that date. I'm looking for any date that is 365 days prior to today, it will return the name value. I've tried today()-365 and today()<365, but nothing is being pulled in the array.

    Thank you for your help! I have uploaded the file for your review.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 04-07-2016, 03:12 PM
  2. Replies: 1
    Last Post: 02-26-2015, 06:12 PM
  3. [SOLVED] Lookup Date 14 days prior and add multiple values for that date into column
    By Shylmysten in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2013, 02:15 AM
  4. sending an email 7 days prior to a due date
    By tgazzi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2013, 12:28 AM
  5. Replies: 3
    Last Post: 02-03-2012, 05:26 PM
  6. Set alert 30 days prior to date
    By joshpyles12 in forum Excel General
    Replies: 1
    Last Post: 02-01-2012, 07:40 PM
  7. Replies: 3
    Last Post: 11-18-2011, 09:12 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