How to get a value based on a series of dates?

Dave from JBM

I am trying to return the the number of highest level training completed. There is eight columns in my sheet for training completion date: "level 1 completion, level 2 completion, level 3 completion" etc. I made a column called "Training Level" and was hoping to get it to reflect the highest level of training completed based on the dates entered but not even sure where to start.

David Tutwiler

You could use a Nested IF statement using the ISDATE function to check for dates in the columns. Something like:

=IF(ISDATE([level 8 completion]@row), "Level 8", IF(ISDATE([level 7 completion]@row), "Level 7", IF( etc. etc.

David Tutwiler

You could use a Nested IF statement using the ISDATE function to check for dates in the columns. Something like:

=IF(ISDATE([level 8 completion]@row), "Level 8", IF(ISDATE([level 7 completion]@row), "Level 7", IF( etc. etc.