I was wondering if this is possible in Excel 2007.
I have six columns of data,starting in columns AB labeled as follows:
Note column placements may change as data is added.

Letter Sent#1 - this has a "Yes" or "" Value
Letter Sent Date - Date Value
Letter Sent #2 - this has a "Yes' or "" Value
Letter Sent Date - Date Value
Letter Sent # 3 - this has a "Yes" or "" Value
Letter Sent Date - Date Value

I need to look at each date value and find the most recent and then pull in
which it was; Letter Sent #1, or #2 or #3?

Also if I need to change the format in the future for the Letter Sent #1, #2
and #3 to values such as "Yes' or "No" instead "Yes" or "". Would the formula
provided need updated or would it not matter since it is loking at the
maximum date first?