+ Reply to Thread
Results 1 to 4 of 4

Find Next Date - "More Than OR Equal To" Date Given By User

  1. #1
    Registered User
    Join Date
    03-10-2020
    Location
    Birmingham, England
    MS-Off Ver
    Office 365
    Posts
    8

    Find Next Date - "More Than OR Equal To" Date Given By User

    Hi there

    I will appreciate if someone can provide me a noraml formula (not array formula) for the following issue:

    I have a table of dates - From and To.

    In another cell or worksheet - I input a date manually and want a formula in the next cell to find the next date, from the Table > Column Title as "From" which is more than or equal to the date I manually entered. I did find a formula through YouTube but that formula is partially working. Please see example in the attached worksheet. Column "I" is where I manually input the date and column K is where I get the date through a formula from the table.

    Please let me know if you need any further information.

    Kind regards

    Tariq Malik
    Attached Files Attached Files
    Last edited by Tariq Malik; 05-23-2020 at 11:51 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Find Next Date - "More Than OR Equal To" Date Given By User

    2 options
    =XLOOKUP(I9,Table01[From],Table01[From],"",1)

    or
    =AGGREGATE(15,6,Table01[From]/(Table01[From]>=I9),1)

  3. #3
    Registered User
    Join Date
    03-10-2020
    Location
    Birmingham, England
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Find Next Date - "More Than OR Equal To" Date Given By User

    Thank you very much for your help, I will use Xlookup..

    Kind regards

    Tariq

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Find Next Date - "More Than OR Equal To" Date Given By User

    You're welcome & thanks for the feedback.

+ 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. Pivot Tabel Custom Date Filter "before or equal to: This Date Last Year
    By MrMims82 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2019, 05:22 PM
  2. Replace date in "DD.MM.YYYY" with date "DD/MM/YYYY" format as soon as user hits enter
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2019, 09:12 AM
  3. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  4. Replies: 0
    Last Post: 11-23-2015, 04:50 AM
  5. [SOLVED] Staic Date Stamp for adjacent cell being equal to "Dormant"
    By singerbatfink in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-09-2014, 09:36 AM
  6. Return "green", "yellow" or "red" from date/age and priority ranking
    By Cantaloop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 12:12 AM
  7. Replies: 1
    Last Post: 09-15-2010, 01:55 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