Detect oldest date in a range

[Heterodoxy]

I know that there's probably a simple answer for my question, but I can't seem to get my mind wrapped around finding a answer!
I have a worksheet that in column (A) there are several employee names, in column (B) are their corresponding employee numbers, and in column (C) are their corresponding hire dates, and finally in the next five columns are cells to enter dates. Looks something like this:

A | B | C | D | E | F | G | H |
6 Tom | 4862 | 05/14/10 | 05/10/15 | 06/10/15 |
7 Fred | 5287 | 07/30/11 | 05/23/15 | 06/24/15 |
8 Mac | 6812 | 02/21/12 | 05/27/15 | |
9 Jack | 6958 | 03/11/12 | 05/12/15 | |

This worksheet is used for tracking days that each employee preformed a certain task, so it’s a rotation schedule based on who hasn’t done the task in the longest time,
so in this case it would be Jack, because he last done it on 05/12/15.

What I’m wanting to do is automate the selection process based on the dates within range of D6:D34
I know that =MIN(D6:J34) will get me the oldest date within the range, but then it needs to look to the right of that cell and see if there is a date in it
and if so move on to the next oldest date and perform the process all over again because =MIN(D6:J34) will yield 05/10/15 (Tom) when I need it to tell me
that actually it’s Jack that should be up next !

Please Help, because I’ve been racking my brain trying to do this and have
used up no telling how much bandwidth googling this headache

Thanks
Heterodoxy

[Glenn Kennedy]

Here's one way (uses a helper colum to find the latest entry per row):

=LOOKUP(1E+100,C2:H2)

followed by an index match to see who's next:

=INDEX($A$2:$A$5,MATCH(MIN($I$2:$I$5),$I$2:$I$5,0))

see sheet attached for cell positions, etc.

[FerJo]

Send the book and I will do it in a minute without VBA code... but you'll find the solution to be awesome, I promise!

[Heterodoxy]

It work great!
Thanks for your help

The only change that I had to make was with the [ =LOOKUP(1E+100,C2:H2) ] formula - kept getting a #N/A error
realized that it happen when there wasn't any value in a row that it was looking at - dummy me, but corrected the issue with:
=IF(ISNA(LOOKUP(1E+100,C2:H2)),"",LOOKUP(1E+100,C2:H2))

Thanks Again
Heterodoxy

[Tony Valko]

=IF(ISNA(LOOKUP(1E+100,C2:H2)),"",LOOKUP(1E+100,C2:H2))

If you're using Excel 2007 or later you can reduce that to:

=IFERROR(LOOKUP(1E100,C2:H2),"")