excel - How to find the earliest MMMYY from a date array? -

does know how might find earliest mmmyy array of following form (see column k).

note: date not sorted in ascending order.

code:

sub outputfile() 'capture contract no. in contractno() array dim contractno() string 'capture project title in projecttitle() array dim projecttitle() string 'capture contract start in contractstart() array dim contractstart() date 'capture contract end in contractend() array dim contractend() date  'capture aspq cement in aspqc() array dim aspqc() double 'capture asp sand in aspqs() array dim aspqs() double 'capture asp aggregate in aspqa() array dim aspqa() double  = 2 until isempty(cells(i, 1).value) = + 1 loop  redim contractno(1 - 2) redim projecttitle(1 - 2) redim contractstart(1 - 2) redim contractend(1 - 2) redim aspqc(1 - 2) redim aspqs(1 - 2) redim aspqa(1 - 2)  = 1 ubound(contractno, 1) contractno(i) = cells(i + 1, 1).value projecttitle(i) = cells(i + 1, 2).value contractstart(i) = cells(i + 1, 11).value contractend(i) = cells(i + 1, 12).value aspqc(i) = cells(i + 1, 14).value aspqs(i) = cells(i + 1, 15).value aspqa(i) = cells(i + 1, 16).value next  end sub 

i believe best built in formula in cell.

=text(min(k:k), "mmmyy")