Dear All,

I have the data as following

Jan-Feb 2015
Jan-Mar 2015
Oct-2015
Apr-2015


I try to change as above data to DATE format by use formula

= Text(Date(right(cell, 4),Left(cell,3),always = 1),"MM-YYYY")

Cell means that the column and row that have data

and date that i always use equal 1 i have put any cell =1 and put $R$C at that cell

but it does not work, i get result is #value!

Who have any idea please advice and suggest me?

Be