+ Reply to Thread
Results 1 to 5 of 5

Earliest date that has empty cell next to it, from list of dates

  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    Canberra, Australia
    MS-Off Ver
    Office 365
    Posts
    62

    Earliest date that has empty cell next to it, from list of dates

    Hi
    I have a table of tasks with due dates in a column and a column which indicates if tasks are complete. I have a cell above the table which should display the earliest due date of incomplete tasks - that is the cell (d1) I would like a formula for. I would like to meet the requirement without having a formula that must be copied down in an additional column in the table.

    Notes:
    If a task is complete it will have "y" in the "Complete?" column and if it is incomplete there will be nothing in the "Complete?" column.
    The list of tasks may be long or short and will change regularly.
    The tasks are not necessarily sorted according to due date.
    Not all of the tasks have due dates.

    I have an example below showing the desired result. Thanks for any assistance.
    Capture.PNG
    Last edited by Stuartzz; 10-13-2017 at 08:12 PM.

  2. #2
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Earliest date that has empty cell next to it, from list of dates

    Good evening.
    See if the attachment helps you.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Earliest date that has empty cell next to it, from list of dates

    Good evening.
    If the formula does not find anything, it returns an error.
    You can enter a message if nothing is returned.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-25-2010
    Location
    Canberra, Australia
    MS-Off Ver
    Office 365
    Posts
    62

    Re: Earliest date that has empty cell next to it, from list of dates

    That is fantastic thank you.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,896

    Re: Earliest date that has empty cell next to it, from list of dates

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

    I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

    Thanks again for all your hard work here!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. [SOLVED] Select the earliest and latest dates from a list of dates
    By Hawkmoth1 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-18-2017, 06:54 AM
  2. [SOLVED] Formula to return the 'earliest' and 'latest' dates from a list of dates is not working
    By Hawkmoth1 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-21-2017, 07:14 AM
  3. [SOLVED] Return the earliest and latest dates selected from a list of dates.
    By Hawkmoth1 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 02-01-2017, 09:41 AM
  4. Need a minimum (earliest) date of 4 dates, but only of dates > a specific date.
    By HarvardMajesty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2016, 02:38 AM
  5. [SOLVED] Lookup for the succeeding dates after the earliest date
    By fbgail in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2015, 09:36 AM
  6. Find earliest date on sheet that has an empty field net to it.
    By lvcourtney in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2012, 12:01 PM
  7. Earliest and Latest Dates from a list of names?
    By TimMatrix in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2008, 07:34 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