I have 4 variables (dates in column B) in a worksheet. I am trying to find the most recent date out of the 4 and return the cell value to the left of it (value in column A).

Before, I only had 3 variables and was using a nested if-then-else, which was working pretty good, but now i have another variable, and a nested 4 variable if then else is a lot harder to handle than 3. I was wondering if there is another way to accomlish what I am trying to do.

Any help is greatly appreciated!

edit: I was previously doing this in VBA during a routine that is run. I would like to keep it in VBA so that I do not have to go back and edit files, which is where the data comes from (long story). So I would like to keep it in VBA if possible

This message was edited by robfo0 on 2002-08-26 17:15