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
Maybe:
=TEXT(DATEVALUE(LEFT(A1, 3) & " 1, " & RIGHT(A1, 4)), "MM-YYYY")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Are these really text entries? If so, this will work:
=DATE(RIGHT(A1,4),MONTH(DATEVALUE(LEFT(A1,3)&"1")),1)
Go with Jerry's solution. I forgot to format to MM-YYYY
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks