Assuming your data looks like this:
Date 1 Date 2 Date 3 Date 4 Date 5 Date 6 Results
1 2 3 4 5 5Date 5
5 6 7 8 8Date 4
3 5 7 7Date 3
7 9 9Date 2
4 4Date 1

Tools Options General R1C1 Ref Style
Select the 5 x 6 array of numbers and name it array1.
Select the 1 x 6 array of dates and name it ddate.
Under Results, enter this formula
=INDEX(array1,,COUNTA(array1 R))&INDEX(ddate,,COUNTA(array1 R))
Revert to A1 style, if desired, after you enter the formulas.