+ 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
    6

    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
    MS-Off Ver
    365
    Posts
    7,087

    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
    6

    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
    MS-Off Ver
    365
    Posts
    7,087

    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)

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