Results 1 to 5 of 5

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

Threaded View

  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.

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