excel - Date formatter using a vlookup -

excel - Date formatter using a vlookup -

i'm looking create date formatter i'm having questions.

here's illustration :

30-janv-14 21-feb-14 26-feb-14 03-mars-14

my plan transform text in real date format such 30/01/2014.

i've created formula :

=if(istext(h46);date(20&right(h46; find("-";h46; (find("-";h46)))-1); vlookup(mid(h46;find("-";h46)+1;find("-";h46;find("-";h46)+1)- find("-";h46)-1);$y$57:$z$68;2;false);left(h46;find("-";h46)-1));h46)

basicelly i'm extracting date using left / mid / right , convert month number i've created table ($y$57:$z$68) below retrive number :

janv 1 fev 2 ...

i'm coming here because know if there improve method that, , if there possibility avoid having create table (month / number) such inline table {"janv", "1"; ...

thanks in advance

in excel 2013 cell containing '30-jan-14' alter proper date if alter format of cell general (or text) date. i'm quite sure happened prior 2013 well.

excel date excel-formula