Index Match using text strings and dates

[ConcreteGuy79]

I need help! I've made numerous attempts with no luck. I need M2 to retrieve the text string with latest date. Please help.
I have attached a sample workbook.

Thank you

Sample Workbook.xlsx
Sample Workbook 2.xlsx

[AlKey]

Enter this array formula in M2

Please Login or Register  to view this content.

***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER

[ConcreteGuy79]

This just displays the date. I really need it to display the original text string.
Thanks

[mcmahobt]

Another way, also entered as an array formula. This assumes your dates will always be in the mm/dd/yyyy format:

Please Login or Register  to view this content.

[AlKey]

Ok Here is with text

Please Login or Register  to view this content.

***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER

[ConcreteGuy79]

Is this possible without the array formula?

[José Augusto]

Hi

i use this array formula

Please Login or Register  to view this content.

[AlKey]

Although this is an array formula it doesn't require use for CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

[ConcreteGuy79]

I think we are closer. Although this does what I need it too I can't get it to work on columns N through Z. I am not sure how this formula works but Columns N through Z are also Different tasks that are labeled on row 1 and when I copy the formula it just shows the Set Forms String.

[ConcreteGuy79]

I think I made this more confusing by not posting the actual workbook. I have attached sample workbook 2 for your review. I enter in the data in range O2:AX2 through a user form that I created. I need the range BG2:BS2 to retrieve the information related to the column heading with the latest date. I appreciate your time and I apologize if I made this more confusing.

Thank you