Results 1 to 3 of 3

Select nearest date after specified

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2005
    Location
    Cardiff, Wales
    MS-Off Ver
    Mac 365 & M/S 365
    Posts
    107

    Select nearest date after specified

    Hi all,

    I have already asked this question, but the answer I was given only looked at the nearest date and not the nearest date after.

    So here goes; I have a table that looks at new starters and the date they started, and then a list of dates appointments offered (these dates can and often do precede to person joining us).

    What I’m looking for the first chronological date AFTER the New start Date.

    In row 3 this works; as it is the nearest date, but in row 4 however, it is the nearest date; but occurs before the New start Date, thus is incorrect.

    Thanks in anticipation

    Clash
    Attached Files Attached Files
    Last edited by Clash; 01-30-2014 at 07:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate the nearest date to the result date
    By SuzanneG in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2012, 04:32 AM
  2. [SOLVED] Select nearest value based on two variables
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2012, 04:15 AM
  3. How to find nearest date to that of given
    By TRJJK73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2008, 06:30 PM
  4. [SOLVED] How do I select the nearest date from a ranges of dates?
    By gerrit in forum Excel General
    Replies: 3
    Last Post: 02-12-2006, 12:50 PM
  5. MATCH and nearest date
    By Hardy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2005, 09:03 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