# Solved Nested if for dates?

November 9, 2016 at 10:59:11
Specs: Macintosh
 Hi, I'm trying to use the IF function to compare who performed a task last (based on dates) and whose turn it is now to perform a task. For example, if A did the task on 11/01/16, B on 11/02/16, C on 11/03/16 and D on 11/04/16, the function should return A. A,B,C and D are in cells and there corresponding dates are adjacent to them.

See More: Nested if for dates?

#1
November 9, 2016 at 11:59:04
✔ Best Answer
 re: "A,B,C and D are in cells and there corresponding dates are adjacent to them.""Adjacent" can be to the left or to the right of letters, so I'll cover both situations.The following formulas should find the "lowest" date and return the letter in the corresponding Row.``` A B C 1 A 11/1/2016 =INDEX(\$A\$1:\$B\$4,MATCH(MIN(\$B\$1:\$B\$4),\$B\$1:\$B\$4,0),1) 2 B 11/2/2016 3 C 11/3/2016 4 D 11/4/2016 `````` A B C 1 11/1/2016 A =VLOOKUP(MIN(\$A\$1:\$A\$4),\$A\$1:\$B\$4,2,0) 2 11/2/2016 B 3 11/3/2016 C 4 11/4/2016 D ```

Report •

#2
November 9, 2016 at 12:08:11
 Shouldn't the sequence always be the same?If A starts then B, C, D.doesn't the sequence then simply repeat,After D, the next should be A again, then B, C, D.Why do you need a formula?MIKEmessage edited by mmcconaghy

Report •
Related Solutions