Hi,
I have four cells with date formats, I2,J2,K2,L2. I need it to select the greatest of the three cells I2, J2, and K2 but not greater than L2. If any of the three I2,J2,K2 blank or null it will still select the greatest of the cells but not greater than L2. If any of the conditions are not met it will select L2 again. I got it half way but it keeps selecting J2. I need it to select the greatest of the three not greater than L2

Here's what I got so far, your thoughts?

=MIN(IF(ISNUMBER(I2:K2),IF(I2:J2<K2,I2:J2,K2),J2), IF(ISBLANK(I2:K2),L2,L2))